{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 项目：游戏产业中新媒体产品设计人员就职参考\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 1.数据爬取\n",
    "方法流程：\n",
    "1. 使用 requests-html 爬取猎聘网站，并存取网页相关文字档\n",
    "2. 使用xpath语法\n",
    "3. 拆解分析带有参数的URL，并再从query取出参数\n",
    "4. 将基底URL，加上参数字典，请求新网页连续爬取数据\n",
    "5. 导出数据\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 使用模块\n",
    "import pandas as pd\n",
    "from requests_html import HTMLSession\n",
    "from urllib.parse import urlparse, parse_qs"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 1.1获取行业参数"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'互联网/电商': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_01&jobKind=&industries=040&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '游戏产业': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_01&jobKind=&industries=420&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '计算机软件': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_01&jobKind=&industries=010&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " 'IT服务': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_01&jobKind=&industries=030&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '电子/芯片/半导体': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_02&jobKind=&industries=050&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '通信业': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_02&jobKind=&industries=060&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '计算机/网络设备': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_02&jobKind=&industries=020&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '房地产/建筑': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_03&jobKind=&industries=080&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '规划/设计/装潢': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_03&jobKind=&industries=100&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '房地产服务': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_03&jobKind=&industries=090&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '银行': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_04&jobKind=&industries=130&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '保险': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_04&jobKind=&industries=140&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '基金/证券/投资': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_04&jobKind=&industries=150&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '会计/审计': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_04&jobKind=&industries=430&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '信托/担保/拍卖': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_04&jobKind=&industries=500&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '快消品': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_05&jobKind=&industries=190&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '批发零售': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_05&jobKind=&industries=240&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '服装纺织': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_05&jobKind=&industries=200&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '家具/家电': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_05&jobKind=&industries=210&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '办公设备': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_05&jobKind=&industries=220&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '奢侈品/收藏品': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_05&jobKind=&industries=460&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '珠宝/玩具/工艺品': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_05&jobKind=&industries=470&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '汽车/摩托车': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_06&jobKind=&industries=350&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '机械/机电/重工': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_06&jobKind=&industries=360&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '印刷/包装/造纸': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_06&jobKind=&industries=180&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '原材料加工': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_06&jobKind=&industries=370&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '仪器/电气/自动化': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_06&jobKind=&industries=340&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '制药/生物工程': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_10&jobKind=&industries=270&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '医疗/保健/美容': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_10&jobKind=&industries=280&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '医疗器械': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_10&jobKind=&industries=290&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '能源/水利': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_11&jobKind=&industries=330&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '石油/化工': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_11&jobKind=&industries=310&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '采掘/冶炼/矿产': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_11&jobKind=&industries=320&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '环保': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_11&jobKind=&industries=300&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '新能源': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_11&jobKind=&industries=490&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '专业服务': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_07&jobKind=&industries=120&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '中介服务': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_07&jobKind=&industries=110&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '外包服务': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_07&jobKind=&industries=440&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '检测/认证': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_07&jobKind=&industries=450&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '餐饮/酒旅/服务': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_07&jobKind=&industries=230&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '文体娱乐': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_07&jobKind=&industries=260&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '租赁服务': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_07&jobKind=&industries=510&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '广告/市场/会展': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_08&jobKind=&industries=070&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '影视文化': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_08&jobKind=&industries=170&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '教育培训': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_08&jobKind=&industries=380&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '交通/物流/运输': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_09&jobKind=&industries=250&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '贸易/进出口': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_09&jobKind=&industries=160&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '航空/航天': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_09&jobKind=&industries=480&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '政务/公共服务': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_12&jobKind=&industries=390&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '农林牧渔': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_12&jobKind=&industries=410&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6',\n",
       " '其他行业': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_12&jobKind=&industries=400&compscale=&key=UI&siTag=cf9xUm0V24brUPysJF0YOw%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=55ef5b5e5d006de89a2e2ad7b1cbc9f6&d_curPage=0&d_pageSize=40&d_headId=55ef5b5e5d006de89a2e2ad7b1cbc9f6'}"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "url = \"https://www.liepin.com/zhaopin/?key=UI\"\n",
    "session = HTMLSession()\n",
    "r = session.get( url )\n",
    "\n",
    "行业数据选择器链结 = r.html.xpath('//ul[@class=\"clearfix\"]/li/div/a')\n",
    "行业数据选择器链结\n",
    "\n",
    "# 爬起行业数据链接的文字以及链接\n",
    "行业数据选择器链结 = { x.xpath(\"a/text()\")[0]:x.xpath(\"a/@href\")[0] for x in 行业数据选择器链结}#注意\"\"\n",
    "行业数据选择器链结"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 51 entries, 0 to 50\n",
      "Data columns (total 6 columns):\n",
      " #   Column    Non-Null Count  Dtype \n",
      "---  ------    --------------  ----- \n",
      " 0   scheme    51 non-null     object\n",
      " 1   netloc    51 non-null     object\n",
      " 2   path      51 non-null     object\n",
      " 3   params    51 non-null     object\n",
      " 4   query     51 non-null     object\n",
      " 5   fragment  51 non-null     object\n",
      "dtypes: object(6)\n",
      "memory usage: 2.5+ KB\n",
      "scheme       1\n",
      "netloc       1\n",
      "path         1\n",
      "params       1\n",
      "query       51\n",
      "fragment     1\n",
      "dtype: int64\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>scheme</th>\n",
       "      <th>netloc</th>\n",
       "      <th>path</th>\n",
       "      <th>params</th>\n",
       "      <th>query</th>\n",
       "      <th>fragment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>/zhaopin/</td>\n",
       "      <td></td>\n",
       "      <td>flushckid=1&amp;compkind=&amp;dqs=&amp;pubTime=&amp;pageSize=4...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  scheme netloc       path params  \\\n",
       "0                /zhaopin/          \n",
       "\n",
       "                                               query fragment  \n",
       "0  flushckid=1&compkind=&dqs=&pubTime=&pageSize=4...           "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# urlparsee：scheme(机制)丶netloc(网络位置)丶path(路径)丶params(路径段参数)丶query(查询)丶fragment(片段)。\n",
    "df = pd.DataFrame([ urlparse(x) for x in 行业数据选择器链结.values()])\n",
    "df.info()\n",
    "print(df.nunique())\n",
    "df.head(1)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 1.2 query 再解析\n",
    "- df_qs = pd.DataFrame([ parse_qs(x) for x in df['query'] ])\n",
    "- parse_qs返回query(查询)多个部分\n",
    "- 找寻到关键参数--industryType、industries\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "flushckid        1\n",
      "pageSize         1\n",
      "industryType    12\n",
      "industries      51\n",
      "key              1\n",
      "siTag            1\n",
      "d_sfrom          1\n",
      "d_ckId           1\n",
      "d_curPage        1\n",
      "d_pageSize       1\n",
      "d_headId         1\n",
      "dtype: int64\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>flushckid</th>\n",
       "      <th>pageSize</th>\n",
       "      <th>industryType</th>\n",
       "      <th>industries</th>\n",
       "      <th>key</th>\n",
       "      <th>siTag</th>\n",
       "      <th>d_sfrom</th>\n",
       "      <th>d_ckId</th>\n",
       "      <th>d_curPage</th>\n",
       "      <th>d_pageSize</th>\n",
       "      <th>d_headId</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>40</td>\n",
       "      <td>industry_01</td>\n",
       "      <td>040</td>\n",
       "      <td>UI</td>\n",
       "      <td>cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>55ef5b5e5d006de89a2e2ad7b1cbc9f6</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>55ef5b5e5d006de89a2e2ad7b1cbc9f6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>40</td>\n",
       "      <td>industry_01</td>\n",
       "      <td>420</td>\n",
       "      <td>UI</td>\n",
       "      <td>cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>55ef5b5e5d006de89a2e2ad7b1cbc9f6</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>55ef5b5e5d006de89a2e2ad7b1cbc9f6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>40</td>\n",
       "      <td>industry_01</td>\n",
       "      <td>010</td>\n",
       "      <td>UI</td>\n",
       "      <td>cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>55ef5b5e5d006de89a2e2ad7b1cbc9f6</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>55ef5b5e5d006de89a2e2ad7b1cbc9f6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>40</td>\n",
       "      <td>industry_01</td>\n",
       "      <td>030</td>\n",
       "      <td>UI</td>\n",
       "      <td>cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>55ef5b5e5d006de89a2e2ad7b1cbc9f6</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>55ef5b5e5d006de89a2e2ad7b1cbc9f6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>40</td>\n",
       "      <td>industry_02</td>\n",
       "      <td>050</td>\n",
       "      <td>UI</td>\n",
       "      <td>cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>55ef5b5e5d006de89a2e2ad7b1cbc9f6</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>55ef5b5e5d006de89a2e2ad7b1cbc9f6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  flushckid pageSize industryType industries key  \\\n",
       "0         1       40  industry_01        040  UI   \n",
       "1         1       40  industry_01        420  UI   \n",
       "2         1       40  industry_01        010  UI   \n",
       "3         1       40  industry_01        030  UI   \n",
       "4         1       40  industry_02        050  UI   \n",
       "\n",
       "                                           siTag         d_sfrom  \\\n",
       "0  cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw  search_unknown   \n",
       "1  cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw  search_unknown   \n",
       "2  cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw  search_unknown   \n",
       "3  cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw  search_unknown   \n",
       "4  cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw  search_unknown   \n",
       "\n",
       "                             d_ckId d_curPage d_pageSize  \\\n",
       "0  55ef5b5e5d006de89a2e2ad7b1cbc9f6         0         40   \n",
       "1  55ef5b5e5d006de89a2e2ad7b1cbc9f6         0         40   \n",
       "2  55ef5b5e5d006de89a2e2ad7b1cbc9f6         0         40   \n",
       "3  55ef5b5e5d006de89a2e2ad7b1cbc9f6         0         40   \n",
       "4  55ef5b5e5d006de89a2e2ad7b1cbc9f6         0         40   \n",
       "\n",
       "                           d_headId  \n",
       "0  55ef5b5e5d006de89a2e2ad7b1cbc9f6  \n",
       "1  55ef5b5e5d006de89a2e2ad7b1cbc9f6  \n",
       "2  55ef5b5e5d006de89a2e2ad7b1cbc9f6  \n",
       "3  55ef5b5e5d006de89a2e2ad7b1cbc9f6  \n",
       "4  55ef5b5e5d006de89a2e2ad7b1cbc9f6  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_qs = pd.DataFrame([{k:v[0] for k,v in parse_qs(x).items()} for x in df['query'] ])\n",
    "print (df_qs.nunique())\n",
    "df_qs.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 1.3 建构行业参数模板"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['040'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6']}\n",
      "{'互联网/电商': '040', '游戏产业': '420', '计算机软件': '010', 'IT服务': '030', '电子/芯片/半导体': '050', '通信业': '060', '计算机/网络设备': '020', '房地产/建筑': '080', '规划/设计/装潢': '100', '房地产服务': '090', '银行': '130', '保险': '140', '基金/证券/投资': '150', '会计/审计': '430', '信托/担保/拍卖': '500', '快消品': '190', '批发零售': '240', '服装纺织': '200', '家具/家电': '210', '办公设备': '220', '奢侈品/收藏品': '460', '珠宝/玩具/工艺品': '470', '汽车/摩托车': '350', '机械/机电/重工': '360', '印刷/包装/造纸': '180', '原材料加工': '370', '仪器/电气/自动化': '340', '制药/生物工程': '270', '医疗/保健/美容': '280', '医疗器械': '290', '能源/水利': '330', '石油/化工': '310', '采掘/冶炼/矿产': '320', '环保': '300', '新能源': '490', '专业服务': '120', '中介服务': '110', '外包服务': '440', '检测/认证': '450', '餐饮/酒旅/服务': '230', '文体娱乐': '260', '租赁服务': '510', '广告/市场/会展': '070', '影视文化': '170', '教育培训': '380', '交通/物流/运输': '250', '贸易/进出口': '160', '航空/航天': '480', '政务/公共服务': '390', '农林牧渔': '410', '其他行业': '400'}\n"
     ]
    }
   ],
   "source": [
    "def parse_url_qs_for_industries (url):\n",
    "    six_parts = urlparse(url) \n",
    "    out = parse_qs(six_parts.query)\n",
    "    return (out)\n",
    "\n",
    "# parse_url_qs_for_compTag(list(公司数据选择器链结.values())[0])['compTag']\n",
    "参数模板 = parse_url_qs_for_industries(list(行业数据选择器链结.values())[0])\n",
    "print(参数模板)\n",
    "\n",
    "[ parse_url_qs_for_industries(x)['industries'][0] for x in 行业数据选择器链结.values()]\n",
    "\n",
    "字典_industries = { k:parse_url_qs_for_industries(v)['industries'][0] for k,v in 行业数据选择器链结.items()}\n",
    "print (字典_industries)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'互联网/电商': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['040'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '游戏产业': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['420'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '计算机软件': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['010'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, 'IT服务': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['030'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '电子/芯片/半导体': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['050'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '通信业': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['060'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '计算机/网络设备': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['020'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '房地产/建筑': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['080'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '规划/设计/装潢': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['100'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '房地产服务': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['090'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '银行': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['130'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '保险': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['140'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '基金/证券/投资': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['150'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '会计/审计': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['430'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '信托/担保/拍卖': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['500'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '快消品': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['190'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '批发零售': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['240'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '服装纺织': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['200'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '家具/家电': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['210'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '办公设备': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['220'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '奢侈品/收藏品': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['460'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '珠宝/玩具/工艺品': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['470'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '汽车/摩托车': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['350'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '机械/机电/重工': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['360'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '印刷/包装/造纸': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['180'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '原材料加工': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['370'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '仪器/电气/自动化': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['340'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '制药/生物工程': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['270'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '医疗/保健/美容': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['280'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '医疗器械': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['290'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '能源/水利': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['330'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '石油/化工': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['310'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '采掘/冶炼/矿产': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['320'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '环保': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['300'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '新能源': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['490'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '专业服务': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['120'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '中介服务': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['110'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '外包服务': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['440'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '检测/认证': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['450'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '餐饮/酒旅/服务': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['230'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '文体娱乐': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['260'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '租赁服务': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['510'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '广告/市场/会展': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['070'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '影视文化': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['170'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '教育培训': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['380'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '交通/物流/运输': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['250'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '贸易/进出口': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['160'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '航空/航天': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['480'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '政务/公共服务': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['390'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '农林牧渔': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['410'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}, '其他行业': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['400'], 'key': ['UI'], 'siTag': ['cf9xUm0V24brUPysJF0YOw~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['55ef5b5e5d006de89a2e2ad7b1cbc9f6'], 'keyword': ['UI']}}\n"
     ]
    }
   ],
   "source": [
    "def 参数模板生成(industries, keyword ):\n",
    "    参数 = 参数模板.copy()\n",
    "    参数['industries'] = industries\n",
    "    参数['keyword'] = keyword\n",
    "    return (参数)\n",
    "\n",
    "# UI 界面设计\n",
    "\n",
    "参数_industries_UI = { k:参数模板生成(industries = [v], keyword = ['UI']) for k,v in 字典_industries.items()}\n",
    "print(参数_industries_UI)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 1.4 参数翻页爬取"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 1.4.1 单页"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "url = \"https://www.liepin.com/zhaopin/?keyword=UI\"\n",
    "session = HTMLSession()\n",
    "r = session.get( url )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[<Element 'a' href='/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=37d92afab4733e8c001586242462cf62&d_curPage=0&d_pageSize=40&d_headId=37d92afab4733e8c001586242462cf62&curPage=1'>, <Element 'a' href='/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=37d92afab4733e8c001586242462cf62&d_curPage=0&d_pageSize=40&d_headId=37d92afab4733e8c001586242462cf62&curPage=2'>, <Element 'a' href='/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=37d92afab4733e8c001586242462cf62&d_curPage=0&d_pageSize=40&d_headId=37d92afab4733e8c001586242462cf62&curPage=3'>, <Element 'a' href='/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=37d92afab4733e8c001586242462cf62&d_curPage=0&d_pageSize=40&d_headId=37d92afab4733e8c001586242462cf62&curPage=4'>, <Element 'a' href='/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=37d92afab4733e8c001586242462cf62&d_curPage=0&d_pageSize=40&d_headId=37d92afab4733e8c001586242462cf62&curPage=1'>, <Element 'a' class=('last',) href='/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=37d92afab4733e8c001586242462cf62&d_curPage=0&d_pageSize=40&d_headId=37d92afab4733e8c001586242462cf62&curPage=9' title='末页'>]\n",
      "{'2': '/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=37d92afab4733e8c001586242462cf62&d_curPage=0&d_pageSize=40&d_headId=37d92afab4733e8c001586242462cf62&curPage=1', '3': '/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=37d92afab4733e8c001586242462cf62&d_curPage=0&d_pageSize=40&d_headId=37d92afab4733e8c001586242462cf62&curPage=2', '4': '/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=37d92afab4733e8c001586242462cf62&d_curPage=0&d_pageSize=40&d_headId=37d92afab4733e8c001586242462cf62&curPage=3', '5': '/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=37d92afab4733e8c001586242462cf62&d_curPage=0&d_pageSize=40&d_headId=37d92afab4733e8c001586242462cf62&curPage=4', '下一页': '/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=37d92afab4733e8c001586242462cf62&d_curPage=0&d_pageSize=40&d_headId=37d92afab4733e8c001586242462cf62&curPage=1', '': '/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=37d92afab4733e8c001586242462cf62&d_curPage=0&d_pageSize=40&d_headId=37d92afab4733e8c001586242462cf62&curPage=9'}\n"
     ]
    }
   ],
   "source": [
    "# 翻一页\n",
    "# xpath 解析翻页a/@href\n",
    "xpath_翻页a = '//div[@class=\"pagerbar\"]/a' # 有disabled, current等href是javascript\n",
    "xpath_翻页a = '//div[@class=\"pagerbar\"]/a[starts-with(@href,\"/zhaopin\")]'\n",
    "print (r.html.xpath(xpath_翻页a)) # 物件\n",
    "\n",
    "href_列表 = [x.xpath('//@href')[0] for x in r.html.xpath(xpath_翻页a)]\n",
    "#print (href_列表)\n",
    "\n",
    "文字_列表 = [x.text for x in r.html.xpath(xpath_翻页a)]\n",
    "#print (文字_列表)\n",
    "\n",
    "href_字典 = {x.text:x.xpath('//@href')[0]  for x in r.html.xpath(xpath_翻页a)}\n",
    "print (href_字典)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 解析翻页链接，找到关键结构"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>scheme</th>\n",
       "      <th>netloc</th>\n",
       "      <th>path</th>\n",
       "      <th>params</th>\n",
       "      <th>query</th>\n",
       "      <th>fragment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>/zhaopin/</td>\n",
       "      <td></td>\n",
       "      <td>compkind=&amp;dqs=&amp;pubTime=&amp;pageSize=40&amp;salary=&amp;co...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>/zhaopin/</td>\n",
       "      <td></td>\n",
       "      <td>compkind=&amp;dqs=&amp;pubTime=&amp;pageSize=40&amp;salary=&amp;co...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>/zhaopin/</td>\n",
       "      <td></td>\n",
       "      <td>compkind=&amp;dqs=&amp;pubTime=&amp;pageSize=40&amp;salary=&amp;co...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>/zhaopin/</td>\n",
       "      <td></td>\n",
       "      <td>compkind=&amp;dqs=&amp;pubTime=&amp;pageSize=40&amp;salary=&amp;co...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>/zhaopin/</td>\n",
       "      <td></td>\n",
       "      <td>compkind=&amp;dqs=&amp;pubTime=&amp;pageSize=40&amp;salary=&amp;co...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>/zhaopin/</td>\n",
       "      <td></td>\n",
       "      <td>compkind=&amp;dqs=&amp;pubTime=&amp;pageSize=40&amp;salary=&amp;co...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  scheme netloc       path params  \\\n",
       "0                /zhaopin/          \n",
       "1                /zhaopin/          \n",
       "2                /zhaopin/          \n",
       "3                /zhaopin/          \n",
       "4                /zhaopin/          \n",
       "5                /zhaopin/          \n",
       "\n",
       "                                               query fragment  \n",
       "0  compkind=&dqs=&pubTime=&pageSize=40&salary=&co...           \n",
       "1  compkind=&dqs=&pubTime=&pageSize=40&salary=&co...           \n",
       "2  compkind=&dqs=&pubTime=&pageSize=40&salary=&co...           \n",
       "3  compkind=&dqs=&pubTime=&pageSize=40&salary=&co...           \n",
       "4  compkind=&dqs=&pubTime=&pageSize=40&salary=&co...           \n",
       "5  compkind=&dqs=&pubTime=&pageSize=40&salary=&co...           "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "scheme      1\n",
      "netloc      1\n",
      "path        1\n",
      "params      1\n",
      "query       5\n",
      "fragment    1\n",
      "dtype: int64\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>pageSize</th>\n",
       "      <th>sortFlag</th>\n",
       "      <th>siTag</th>\n",
       "      <th>d_sfrom</th>\n",
       "      <th>d_ckId</th>\n",
       "      <th>d_curPage</th>\n",
       "      <th>d_pageSize</th>\n",
       "      <th>d_headId</th>\n",
       "      <th>curPage</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>40</td>\n",
       "      <td>°radeFlag=0</td>\n",
       "      <td>1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>37d92afab4733e8c001586242462cf62</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>37d92afab4733e8c001586242462cf62</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>40</td>\n",
       "      <td>°radeFlag=0</td>\n",
       "      <td>1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>37d92afab4733e8c001586242462cf62</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>37d92afab4733e8c001586242462cf62</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>40</td>\n",
       "      <td>°radeFlag=0</td>\n",
       "      <td>1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>37d92afab4733e8c001586242462cf62</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>37d92afab4733e8c001586242462cf62</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>40</td>\n",
       "      <td>°radeFlag=0</td>\n",
       "      <td>1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>37d92afab4733e8c001586242462cf62</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>37d92afab4733e8c001586242462cf62</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>40</td>\n",
       "      <td>°radeFlag=0</td>\n",
       "      <td>1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>37d92afab4733e8c001586242462cf62</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>37d92afab4733e8c001586242462cf62</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>40</td>\n",
       "      <td>°radeFlag=0</td>\n",
       "      <td>1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>37d92afab4733e8c001586242462cf62</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>37d92afab4733e8c001586242462cf62</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  pageSize     sortFlag                                          siTag  \\\n",
       "0       40  °radeFlag=0  1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw   \n",
       "1       40  °radeFlag=0  1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw   \n",
       "2       40  °radeFlag=0  1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw   \n",
       "3       40  °radeFlag=0  1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw   \n",
       "4       40  °radeFlag=0  1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw   \n",
       "5       40  °radeFlag=0  1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw   \n",
       "\n",
       "          d_sfrom                            d_ckId d_curPage d_pageSize  \\\n",
       "0  search_unknown  37d92afab4733e8c001586242462cf62         0         40   \n",
       "1  search_unknown  37d92afab4733e8c001586242462cf62         0         40   \n",
       "2  search_unknown  37d92afab4733e8c001586242462cf62         0         40   \n",
       "3  search_unknown  37d92afab4733e8c001586242462cf62         0         40   \n",
       "4  search_unknown  37d92afab4733e8c001586242462cf62         0         40   \n",
       "5  search_unknown  37d92afab4733e8c001586242462cf62         0         40   \n",
       "\n",
       "                           d_headId curPage  \n",
       "0  37d92afab4733e8c001586242462cf62       1  \n",
       "1  37d92afab4733e8c001586242462cf62       2  \n",
       "2  37d92afab4733e8c001586242462cf62       3  \n",
       "3  37d92afab4733e8c001586242462cf62       4  \n",
       "4  37d92afab4733e8c001586242462cf62       1  \n",
       "5  37d92afab4733e8c001586242462cf62       9  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "pageSize      1\n",
      "sortFlag      1\n",
      "siTag         1\n",
      "d_sfrom       1\n",
      "d_ckId        1\n",
      "d_curPage     1\n",
      "d_pageSize    1\n",
      "d_headId      1\n",
      "curPage       5\n",
      "dtype: int64\n"
     ]
    }
   ],
   "source": [
    "# 模块\n",
    "from urllib.parse import urlparse, parse_qs\n",
    "import pandas as pd\n",
    "from IPython.display import display, HTML\n",
    "\n",
    "# 输入 href_列表, 建构出参数字典\n",
    "\n",
    "# urlparse 解析后丢入数据框\n",
    "df = pd.DataFrame([ urlparse(x) for x in href_列表])\n",
    "df_qs = pd.DataFrame([{k:v[0] for k,v in parse_qs(x).items()} for x in df['query'] ])\n",
    "\n",
    "display(df)\n",
    "print(df.nunique())\n",
    "display(df_qs)\n",
    "print(df_qs.nunique())\n",
    "\n",
    "df_qs.curPage\n",
    "df_qs = df_qs.assign (curPage_int=df_qs.curPage.astype(int)) # 变成整数"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 1.4.2 建构多页翻页参数模板"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'pageSize': ['40'], 'sortFlag': ['°radeFlag=0'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['37d92afab4733e8c001586242462cf62'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['37d92afab4733e8c001586242462cf62'], 'curPage': ['1']}\n",
      "{'2': '/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=37d92afab4733e8c001586242462cf62&d_curPage=0&d_pageSize=40&d_headId=37d92afab4733e8c001586242462cf62&curPage=1', '3': '/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=37d92afab4733e8c001586242462cf62&d_curPage=0&d_pageSize=40&d_headId=37d92afab4733e8c001586242462cf62&curPage=2', '4': '/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=37d92afab4733e8c001586242462cf62&d_curPage=0&d_pageSize=40&d_headId=37d92afab4733e8c001586242462cf62&curPage=3', '5': '/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=37d92afab4733e8c001586242462cf62&d_curPage=0&d_pageSize=40&d_headId=37d92afab4733e8c001586242462cf62&curPage=4', '下一页': '/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=37d92afab4733e8c001586242462cf62&d_curPage=0&d_pageSize=40&d_headId=37d92afab4733e8c001586242462cf62&curPage=1', '': '/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=37d92afab4733e8c001586242462cf62&d_curPage=0&d_pageSize=40&d_headId=37d92afab4733e8c001586242462cf62&curPage=9'}\n"
     ]
    }
   ],
   "source": [
    "def parse_url_qs_for_curPage (url):\n",
    "    six_parts = urlparse(url) \n",
    "    out = parse_qs(six_parts.query)\n",
    "    return (out)\n",
    "\n",
    "# 取一例做模板\n",
    "参数模板 = parse_url_qs_for_curPage(href_列表[0])\n",
    "print (参数模板)\n",
    "\n",
    "print (href_字典)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1\n",
      "9\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "{0: {'pageSize': ['40'],\n",
       "  'sortFlag': ['°radeFlag=0'],\n",
       "  'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['37d92afab4733e8c001586242462cf62'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['37d92afab4733e8c001586242462cf62'],\n",
       "  'curPage': [0],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'key': ['UI']},\n",
       " 1: {'pageSize': ['40'],\n",
       "  'sortFlag': ['°radeFlag=0'],\n",
       "  'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['37d92afab4733e8c001586242462cf62'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['37d92afab4733e8c001586242462cf62'],\n",
       "  'curPage': [1],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'key': ['UI']},\n",
       " 2: {'pageSize': ['40'],\n",
       "  'sortFlag': ['°radeFlag=0'],\n",
       "  'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['37d92afab4733e8c001586242462cf62'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['37d92afab4733e8c001586242462cf62'],\n",
       "  'curPage': [2],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'key': ['UI']},\n",
       " 3: {'pageSize': ['40'],\n",
       "  'sortFlag': ['°radeFlag=0'],\n",
       "  'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['37d92afab4733e8c001586242462cf62'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['37d92afab4733e8c001586242462cf62'],\n",
       "  'curPage': [3],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'key': ['UI']},\n",
       " 4: {'pageSize': ['40'],\n",
       "  'sortFlag': ['°radeFlag=0'],\n",
       "  'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['37d92afab4733e8c001586242462cf62'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['37d92afab4733e8c001586242462cf62'],\n",
       "  'curPage': [4],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'key': ['UI']},\n",
       " 5: {'pageSize': ['40'],\n",
       "  'sortFlag': ['°radeFlag=0'],\n",
       "  'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['37d92afab4733e8c001586242462cf62'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['37d92afab4733e8c001586242462cf62'],\n",
       "  'curPage': [5],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'key': ['UI']},\n",
       " 6: {'pageSize': ['40'],\n",
       "  'sortFlag': ['°radeFlag=0'],\n",
       "  'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['37d92afab4733e8c001586242462cf62'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['37d92afab4733e8c001586242462cf62'],\n",
       "  'curPage': [6],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'key': ['UI']},\n",
       " 7: {'pageSize': ['40'],\n",
       "  'sortFlag': ['°radeFlag=0'],\n",
       "  'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['37d92afab4733e8c001586242462cf62'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['37d92afab4733e8c001586242462cf62'],\n",
       "  'curPage': [7],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'key': ['UI']},\n",
       " 8: {'pageSize': ['40'],\n",
       "  'sortFlag': ['°radeFlag=0'],\n",
       "  'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['37d92afab4733e8c001586242462cf62'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['37d92afab4733e8c001586242462cf62'],\n",
       "  'curPage': [8],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'key': ['UI']},\n",
       " 9: {'pageSize': ['40'],\n",
       "  'sortFlag': ['°radeFlag=0'],\n",
       "  'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['37d92afab4733e8c001586242462cf62'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['37d92afab4733e8c001586242462cf62'],\n",
       "  'curPage': [9],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'key': ['UI']}}"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def 参数模板生成(industryType,industries,curPage,key):\n",
    "    参数 = 参数模板.copy()\n",
    "    参数['industryType'] = industryType\n",
    "    参数['industries'] = industries\n",
    "    参数['curPage'] = curPage\n",
    "    参数['key'] = key\n",
    "    return (参数)\n",
    "\n",
    "print (df_qs.curPage_int.min()) # 最小值只有1\n",
    "print (df_qs.curPage_int.max()) # 最大值只有9\n",
    "\n",
    "# 应该是 0 (本页)....9(最大值)\n",
    "\n",
    "参数_key_X_curPage = { \n",
    "    i:参数模板生成(industryType=['industry_01'],\\\n",
    "                       industries = ['040'],\\\n",
    "                      curPage = [i], \\\n",
    "                      key = ['UI']) \\\n",
    "    for i in range(0,df_qs.curPage_int.max()+1)\\\n",
    "    }\n",
    "参数_key_X_curPage"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 1.5 网页爬取的数据模板建构"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 参考老师代码\n",
    "\n",
    "session = HTMLSession()\n",
    "\n",
    "def requests_liepin( url, params):\n",
    "    r = session.get( url , params = payload)\n",
    "\n",
    "    # 先取特定元素, 精准打击其子后辈\n",
    "    主要元素 = r.html.xpath( '//ul[@class=\"sojob-list\"]/li')\n",
    "\n",
    "    # 作为xpath字典，键为我要抓的牛肉名称，值为xpath\n",
    "    dict_xpaths={ \n",
    "        'text': {\n",
    "            '学历':      '//div[contains(@class,\"job-info\")]/p/span[@class=\"edu\"]',\n",
    "            '经验':      '//div[contains(@class,\"job-info\")]/p/span[@class=\"edu\"]/following-sibling::span',\n",
    "            '薪水':    '//div[contains(@class,\"job-info\")]/p/span[@class=\"text-warning\"]', \n",
    "            '时间':    '//div[contains(@class,\"job-info\")]/p/time/@title', \n",
    "            '职称':    '//div[contains(@class,\"job-info\")]/h3/a', \n",
    "            '公司地点': '//div[contains(@class,\"job-info\")]/p/a',\n",
    "            '公司名称': '//div[contains(@class,\"sojob-item-main\")]//p[@class=\"company-name\"]/a', \n",
    "        },\n",
    "        'text_content': {\n",
    "        },\n",
    "        'href': {\n",
    "            '链接':    '//div[contains(@class,\"job-info\")]/h3/a', \n",
    "            '公司URL': '//div[contains(@class,\"sojob-item-main\")]//p[@class=\"company-name\"]/a', \n",
    "        }\n",
    "    }\n",
    "\n",
    "    def get_e_text_content(_xpath_):\n",
    "        # 高级列表推导\n",
    "        暂存结果 = [e.xpath(_xpath_)[0].lxml.text_content() for e in 主要元素]\n",
    "        return(暂存结果)\n",
    "\n",
    "    def get_e_text(_xpath_):\n",
    "        # 高级列表推导\n",
    "        暂存结果 = [\"\".join([x.strip() if type(x) is str else x.text.strip() for x in e.xpath(_xpath_)]) for e in 主要元素]\n",
    "        return(暂存结果)\n",
    "\n",
    "    def get_e_href(_xpath_):\n",
    "        # 高级列表推导\n",
    "        暂存结果 = [list(e.xpath(_xpath_, first=True).absolute_links)[0] \\\n",
    "                   if len(e.xpath(_xpath_, first=True).absolute_links) >= 1  \\\n",
    "                   else \"\" for e in 主要元素]\n",
    "        return(暂存结果)\n",
    "\n",
    "    # 只对主要元素下进行.xpath取值\n",
    "    数据字典 = dict()\n",
    "\n",
    "    数据字典 = {k:get_e_text_content(v) for k,v in dict_xpaths['text_content'].items()}\n",
    "    数据字典.update({k:get_e_text(v) for k,v in dict_xpaths['text'].items()})\n",
    "    数据字典.update({k:get_e_href(v) for k,v in dict_xpaths['href'].items()})\n",
    "\n",
    "    数据 = pd.DataFrame(数据字典)\n",
    "    #数据.to_excel(\"20春_Web数据挖掘_week03_liepin.xlsx\", sheet_name=\"搜查结果\")\n",
    "    return (数据)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 1.6 爬虫数据输出"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "UI设计 10\n",
      "UE设计 10\n",
      "原画设计 10\n",
      "特效设计 10\n",
      "模型设计 10\n",
      "Wall time: 4min 40s\n"
     ]
    }
   ],
   "source": [
    "%%time\n",
    "# 多个页面+多个关键词\n",
    "import time\n",
    "from random import random\n",
    "\n",
    "url = \"https://www.liepin.com/zhaopin/\"\n",
    "xpath_翻页a = '//div[@class=\"pagerbar\"]/a[starts-with(@href,\"/zhaopin\")]'\n",
    "\n",
    "keywords = ['UI设计','UE设计','原画设计','特效设计','模型设计']\n",
    "list_df = list()\n",
    "\n",
    "# 选定行业类型为互联网·游戏·软件，行业为互联网/电商\n",
    "for key in keywords:\n",
    "    payload = 参数模板生成(industryType=['industry_01'],industries = ['040'],key=[key], curPage=['0'])\n",
    "    df = requests_liepin( url, params = payload)\n",
    "    href_列表 = [x.xpath('//@href')[0] for x in r.html.xpath(xpath_翻页a)]\n",
    "    df = pd.DataFrame([ urlparse(x) for x in href_列表])\n",
    "    df_qs = pd.DataFrame([{k:v[0] for k,v in parse_qs(x).items()} for x in df['query'] ])\n",
    "    df_qs = df_qs.assign (curPage_int=df_qs.curPage.astype(int)) # 变成整数\n",
    "    长度 = df_qs.curPage_int.max()+1\n",
    "    参数_keyword_X_curPage = { \n",
    "        i:参数模板生成(industryType=['industry_02'],\\\n",
    "                       industries = ['060'],\\\n",
    "                      curPage = [i], \\\n",
    "                      key = [key]) \\\n",
    "        for i in range(0,长度)\\\n",
    "        }\n",
    "    print (key,长度)#10\n",
    "    \n",
    "    for k,v in 参数_keyword_X_curPage.items():\n",
    "        payload = v\n",
    "        df = requests_liepin( url, params = payload)\n",
    "        time.sleep(3+4*random())  #放慢脚步 3-7秒, 平均约5秒\n",
    "        df = df.assign (行业类型 = '互联网·游戏·软件' )\n",
    "        df = df.assign (行业 = '游戏产业')\n",
    "        df = df.assign (关键词 = key)  # 区分  keyword    \n",
    "        df = df.assign (页数 = k)  # 区分  curPage    \n",
    "        list_df.append(df)\n",
    "        \n",
    "df_all = pd.concat(list_df).reset_index()\n",
    "df_all.index.name = '序'\n",
    "\n",
    "# 数据导出\n",
    "df_all.to_excel(\"游戏_产品设计_翻页.xlsx\",\\\n",
    "                sheet_name=\"_\".join(keywords))\n",
    "# 预估时间: 4*5秒*10 =200\n",
    "# 预估数量: 4*40*10 =1600"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>学历</th>\n",
       "      <th>经验</th>\n",
       "      <th>薪水</th>\n",
       "      <th>时间</th>\n",
       "      <th>职称</th>\n",
       "      <th>公司地点</th>\n",
       "      <th>公司名称</th>\n",
       "      <th>链接</th>\n",
       "      <th>公司URL</th>\n",
       "      <th>行业类型</th>\n",
       "      <th>行业</th>\n",
       "      <th>关键词</th>\n",
       "      <th>页数</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>序</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>25-40k·16薪</td>\n",
       "      <td>2020年07月18日</td>\n",
       "      <td>资深ui设计师</td>\n",
       "      <td>上海</td>\n",
       "      <td>千云(上海)信息科技有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1930040433.shtml</td>\n",
       "      <td>https://www.liepin.com/company/12157689/</td>\n",
       "      <td>互联网·游戏·软件</td>\n",
       "      <td>游戏产业</td>\n",
       "      <td>UI设计</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年07月18日</td>\n",
       "      <td>UI设计</td>\n",
       "      <td>镇江</td>\n",
       "      <td>中国联合网络通信有限公司江苏省分公司</td>\n",
       "      <td>https://www.liepin.com/job/1927897597.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8165115/</td>\n",
       "      <td>互联网·游戏·软件</td>\n",
       "      <td>游戏产业</td>\n",
       "      <td>UI设计</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年07月18日</td>\n",
       "      <td>初级UI设计师</td>\n",
       "      <td>南京-建邺区</td>\n",
       "      <td>中国联合网络通信有限公司江苏省分公司</td>\n",
       "      <td>https://www.liepin.com/job/1926982717.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8165115/</td>\n",
       "      <td>互联网·游戏·软件</td>\n",
       "      <td>游戏产业</td>\n",
       "      <td>UI设计</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>学历不限</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>6-12k·12薪</td>\n",
       "      <td>2020年07月18日</td>\n",
       "      <td>ui设计</td>\n",
       "      <td>佛山-顺德区</td>\n",
       "      <td>广东顺德中电信息技术有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1925162677.shtml</td>\n",
       "      <td>https://www.liepin.com/company/10275967/</td>\n",
       "      <td>互联网·游戏·软件</td>\n",
       "      <td>游戏产业</td>\n",
       "      <td>UI设计</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>8-15k·13薪</td>\n",
       "      <td>2020年07月18日</td>\n",
       "      <td>前端界面设计</td>\n",
       "      <td>福州-中亭街</td>\n",
       "      <td>金钱猫科技股份有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1925495583.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8657511/</td>\n",
       "      <td>互联网·游戏·软件</td>\n",
       "      <td>游戏产业</td>\n",
       "      <td>UI设计</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1221</th>\n",
       "      <td>35</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>10-16k·12薪</td>\n",
       "      <td>2020年06月18日</td>\n",
       "      <td>Linux应用工程师</td>\n",
       "      <td>合肥</td>\n",
       "      <td>移远通信</td>\n",
       "      <td>https://www.liepin.com/job/1927210193.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7963157/</td>\n",
       "      <td>互联网·游戏·软件</td>\n",
       "      <td>游戏产业</td>\n",
       "      <td>模型设计</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1222</th>\n",
       "      <td>36</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>8-15k·12薪</td>\n",
       "      <td>2020年06月18日</td>\n",
       "      <td>Linux应用开发工程师(偏数据)</td>\n",
       "      <td>合肥</td>\n",
       "      <td>移远通信</td>\n",
       "      <td>https://www.liepin.com/job/1923452127.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7963157/</td>\n",
       "      <td>互联网·游戏·软件</td>\n",
       "      <td>游戏产业</td>\n",
       "      <td>模型设计</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1223</th>\n",
       "      <td>37</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>40-70k·12薪</td>\n",
       "      <td>2020年06月17日</td>\n",
       "      <td>AI工程架构专家(007776)</td>\n",
       "      <td>深圳-福田区</td>\n",
       "      <td>vivo</td>\n",
       "      <td>https://www.liepin.com/job/1929277271.shtml</td>\n",
       "      <td>https://www.liepin.com/company/4787049/</td>\n",
       "      <td>互联网·游戏·软件</td>\n",
       "      <td>游戏产业</td>\n",
       "      <td>模型设计</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1224</th>\n",
       "      <td>38</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>20-40k·16薪</td>\n",
       "      <td>2020年06月17日</td>\n",
       "      <td>Power软件工程师</td>\n",
       "      <td>深圳,广州,东莞</td>\n",
       "      <td>知名手机公司</td>\n",
       "      <td>https://www.liepin.com/a/20829765.shtml</td>\n",
       "      <td></td>\n",
       "      <td>互联网·游戏·软件</td>\n",
       "      <td>游戏产业</td>\n",
       "      <td>模型设计</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1225</th>\n",
       "      <td>39</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>20-25k·12薪</td>\n",
       "      <td>2020年06月16日</td>\n",
       "      <td>高级数据分析师</td>\n",
       "      <td>深圳</td>\n",
       "      <td>斯凯荣</td>\n",
       "      <td>https://www.liepin.com/job/1922843797.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7936240/</td>\n",
       "      <td>互联网·游戏·软件</td>\n",
       "      <td>游戏产业</td>\n",
       "      <td>模型设计</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1226 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      index     学历     经验          薪水           时间                 职称  \\\n",
       "序                                                                       \n",
       "0         0  本科及以上   3-5年  25-40k·16薪  2020年07月18日            资深ui设计师   \n",
       "1         1   统招本科   经验不限          面议  2020年07月18日               UI设计   \n",
       "2         2   统招本科   1-3年          面议  2020年07月18日            初级UI设计师   \n",
       "3         3   学历不限   经验不限   6-12k·12薪  2020年07月18日               ui设计   \n",
       "4         4   统招本科   1-3年   8-15k·13薪  2020年07月18日             前端界面设计   \n",
       "...     ...    ...    ...         ...          ...                ...   \n",
       "1221     35  本科及以上   1-3年  10-16k·12薪  2020年06月18日         Linux应用工程师   \n",
       "1222     36  本科及以上   3-5年   8-15k·12薪  2020年06月18日  Linux应用开发工程师(偏数据)   \n",
       "1223     37  本科及以上  5-10年  40-70k·12薪  2020年06月17日   AI工程架构专家(007776)   \n",
       "1224     38  本科及以上   1-3年  20-40k·16薪  2020年06月17日         Power软件工程师   \n",
       "1225     39  本科及以上   3-5年  20-25k·12薪  2020年06月16日            高级数据分析师   \n",
       "\n",
       "          公司地点                公司名称  \\\n",
       "序                                    \n",
       "0           上海      千云(上海)信息科技有限公司   \n",
       "1           镇江  中国联合网络通信有限公司江苏省分公司   \n",
       "2       南京-建邺区  中国联合网络通信有限公司江苏省分公司   \n",
       "3       佛山-顺德区      广东顺德中电信息技术有限公司   \n",
       "4       福州-中亭街         金钱猫科技股份有限公司   \n",
       "...        ...                 ...   \n",
       "1221        合肥                移远通信   \n",
       "1222        合肥                移远通信   \n",
       "1223    深圳-福田区                vivo   \n",
       "1224  深圳,广州,东莞              知名手机公司   \n",
       "1225        深圳                 斯凯荣   \n",
       "\n",
       "                                               链接  \\\n",
       "序                                                   \n",
       "0     https://www.liepin.com/job/1930040433.shtml   \n",
       "1     https://www.liepin.com/job/1927897597.shtml   \n",
       "2     https://www.liepin.com/job/1926982717.shtml   \n",
       "3     https://www.liepin.com/job/1925162677.shtml   \n",
       "4     https://www.liepin.com/job/1925495583.shtml   \n",
       "...                                           ...   \n",
       "1221  https://www.liepin.com/job/1927210193.shtml   \n",
       "1222  https://www.liepin.com/job/1923452127.shtml   \n",
       "1223  https://www.liepin.com/job/1929277271.shtml   \n",
       "1224      https://www.liepin.com/a/20829765.shtml   \n",
       "1225  https://www.liepin.com/job/1922843797.shtml   \n",
       "\n",
       "                                         公司URL       行业类型    行业   关键词  页数  \n",
       "序                                                                          \n",
       "0     https://www.liepin.com/company/12157689/  互联网·游戏·软件  游戏产业  UI设计   0  \n",
       "1      https://www.liepin.com/company/8165115/  互联网·游戏·软件  游戏产业  UI设计   0  \n",
       "2      https://www.liepin.com/company/8165115/  互联网·游戏·软件  游戏产业  UI设计   0  \n",
       "3     https://www.liepin.com/company/10275967/  互联网·游戏·软件  游戏产业  UI设计   0  \n",
       "4      https://www.liepin.com/company/8657511/  互联网·游戏·软件  游戏产业  UI设计   0  \n",
       "...                                        ...        ...   ...   ...  ..  \n",
       "1221   https://www.liepin.com/company/7963157/  互联网·游戏·软件  游戏产业  模型设计   9  \n",
       "1222   https://www.liepin.com/company/7963157/  互联网·游戏·软件  游戏产业  模型设计   9  \n",
       "1223   https://www.liepin.com/company/4787049/  互联网·游戏·软件  游戏产业  模型设计   9  \n",
       "1224                                            互联网·游戏·软件  游戏产业  模型设计   9  \n",
       "1225   https://www.liepin.com/company/7936240/  互联网·游戏·软件  游戏产业  模型设计   9  \n",
       "\n",
       "[1226 rows x 14 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 展示\n",
    "df_all"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 2. 数据整理"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 2.1 数据分类"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### UI设计\n",
    "（界面设计）"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>职称</th>\n",
       "      <th>学历</th>\n",
       "      <th>经验</th>\n",
       "      <th>薪水</th>\n",
       "      <th>链接</th>\n",
       "      <th>公司地点</th>\n",
       "      <th>公司名称</th>\n",
       "      <th>页数</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>关键词</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>UI设计</th>\n",
       "      <td>资深ui设计师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>25-40k·16薪</td>\n",
       "      <td>https://www.liepin.com/job/1930040433.shtml</td>\n",
       "      <td>上海</td>\n",
       "      <td>千云(上海)信息科技有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UI设计</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>面议</td>\n",
       "      <td>https://www.liepin.com/job/1927897597.shtml</td>\n",
       "      <td>镇江</td>\n",
       "      <td>中国联合网络通信有限公司江苏省分公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UI设计</th>\n",
       "      <td>初级UI设计师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>面议</td>\n",
       "      <td>https://www.liepin.com/job/1926982717.shtml</td>\n",
       "      <td>南京-建邺区</td>\n",
       "      <td>中国联合网络通信有限公司江苏省分公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UI设计</th>\n",
       "      <td>ui设计</td>\n",
       "      <td>学历不限</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>6-12k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1925162677.shtml</td>\n",
       "      <td>佛山-顺德区</td>\n",
       "      <td>广东顺德中电信息技术有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UI设计</th>\n",
       "      <td>前端界面设计</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>8-15k·13薪</td>\n",
       "      <td>https://www.liepin.com/job/1925495583.shtml</td>\n",
       "      <td>福州-中亭街</td>\n",
       "      <td>金钱猫科技股份有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UI设计</th>\n",
       "      <td>GUI视觉创意经理（外销）(004...</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>30-60k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929565837.shtml</td>\n",
       "      <td>深圳</td>\n",
       "      <td>vivo</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UI设计</th>\n",
       "      <td>Android开发工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>8-10k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929564671.shtml</td>\n",
       "      <td></td>\n",
       "      <td>彩讯科技股份有限公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UI设计</th>\n",
       "      <td>java开发</td>\n",
       "      <td>硕士及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>6-12k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1926869813.shtml</td>\n",
       "      <td>西安</td>\n",
       "      <td>国家无线电频谱管理研究所有限公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UI设计</th>\n",
       "      <td>Android系统</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>16-28k·13薪</td>\n",
       "      <td>https://www.liepin.com/a/20637785.shtml</td>\n",
       "      <td>杭州</td>\n",
       "      <td>某科技外包公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UI设计</th>\n",
       "      <td>产品经理</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>21-42k·12薪</td>\n",
       "      <td>https://www.liepin.com/a/11975363.shtml</td>\n",
       "      <td></td>\n",
       "      <td>某大型集团公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>400 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        职称     学历    经验          薪水  \\\n",
       "关键词                                                   \n",
       "UI设计               资深ui设计师  本科及以上  3-5年  25-40k·16薪   \n",
       "UI设计                  UI设计   统招本科  经验不限          面议   \n",
       "UI设计               初级UI设计师   统招本科  1-3年          面议   \n",
       "UI设计                  ui设计   学历不限  经验不限   6-12k·12薪   \n",
       "UI设计                前端界面设计   统招本科  1-3年   8-15k·13薪   \n",
       "...                    ...    ...   ...         ...   \n",
       "UI设计  GUI视觉创意经理（外销）(004...  本科及以上  3-5年  30-60k·12薪   \n",
       "UI设计          Android开发工程师  本科及以上  3-5年   8-10k·12薪   \n",
       "UI设计                java开发  硕士及以上  3-5年   6-12k·12薪   \n",
       "UI设计             Android系统  大专及以上  经验不限  16-28k·13薪   \n",
       "UI设计                  产品经理  本科及以上  3-5年  21-42k·12薪   \n",
       "\n",
       "                                               链接    公司地点                公司名称  \\\n",
       "关键词                                                                             \n",
       "UI设计  https://www.liepin.com/job/1930040433.shtml      上海      千云(上海)信息科技有限公司   \n",
       "UI设计  https://www.liepin.com/job/1927897597.shtml      镇江  中国联合网络通信有限公司江苏省分公司   \n",
       "UI设计  https://www.liepin.com/job/1926982717.shtml  南京-建邺区  中国联合网络通信有限公司江苏省分公司   \n",
       "UI设计  https://www.liepin.com/job/1925162677.shtml  佛山-顺德区      广东顺德中电信息技术有限公司   \n",
       "UI设计  https://www.liepin.com/job/1925495583.shtml  福州-中亭街         金钱猫科技股份有限公司   \n",
       "...                                           ...     ...                 ...   \n",
       "UI设计  https://www.liepin.com/job/1929565837.shtml      深圳                vivo   \n",
       "UI设计  https://www.liepin.com/job/1929564671.shtml                  彩讯科技股份有限公司   \n",
       "UI设计  https://www.liepin.com/job/1926869813.shtml      西安    国家无线电频谱管理研究所有限公司   \n",
       "UI设计      https://www.liepin.com/a/20637785.shtml      杭州             某科技外包公司   \n",
       "UI设计      https://www.liepin.com/a/11975363.shtml                     某大型集团公司   \n",
       "\n",
       "      页数  \n",
       "关键词       \n",
       "UI设计   0  \n",
       "UI设计   0  \n",
       "UI设计   0  \n",
       "UI设计   0  \n",
       "UI设计   0  \n",
       "...   ..  \n",
       "UI设计   9  \n",
       "UI设计   9  \n",
       "UI设计   9  \n",
       "UI设计   9  \n",
       "UI设计   9  \n",
       "\n",
       "[400 rows x 8 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_UI = df_all[['关键词','职称','学历','经验','薪水','链接','公司地点','公司名称','页数']].set_index(\"关键词\").loc['UI设计']\n",
    "df_UI.to_excel(\"UI设计.xlsx\",\\\n",
    "                sheet_name=\"游戏产业_UI设计\")\n",
    "df_UI"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### UE设计\n",
    "（用户体验设计）"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>职称</th>\n",
       "      <th>学历</th>\n",
       "      <th>经验</th>\n",
       "      <th>薪水</th>\n",
       "      <th>链接</th>\n",
       "      <th>公司地点</th>\n",
       "      <th>公司名称</th>\n",
       "      <th>页数</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>关键词</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>UE设计</th>\n",
       "      <td>122278高级UE4美术设计师</td>\n",
       "      <td>学历不限</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>20-35k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929583359.shtml</td>\n",
       "      <td>深圳-科技园</td>\n",
       "      <td>大疆创新</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UE设计</th>\n",
       "      <td>高级交互设计师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>15-30k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929235759.shtml</td>\n",
       "      <td>深圳</td>\n",
       "      <td>OPPO广东移动通信有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UE设计</th>\n",
       "      <td>120642高级交互设计师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>15-25k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1925734479.shtml</td>\n",
       "      <td>深圳-科技园</td>\n",
       "      <td>大疆创新</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UE设计</th>\n",
       "      <td>122059交互设计师（HMI）</td>\n",
       "      <td>学历不限</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>20-40k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1927324629.shtml</td>\n",
       "      <td>深圳</td>\n",
       "      <td>大疆创新</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UE设计</th>\n",
       "      <td>UE_5G数字电路设计RTL/ASIC工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>20-50k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1922785255.shtml</td>\n",
       "      <td>上海-桃浦</td>\n",
       "      <td>中国电科新一代移动通信创新中心</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UE设计</th>\n",
       "      <td>资深产品经理</td>\n",
       "      <td>硕士及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>16-21k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1928927927.shtml</td>\n",
       "      <td>郑州-中原区</td>\n",
       "      <td>中讯邮电咨询设计院有限公司郑州分公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UE设计</th>\n",
       "      <td>web前端开发工程师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>18-30k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1928195041.shtml</td>\n",
       "      <td>深圳-南山区</td>\n",
       "      <td>深圳市锐尔觅移动通信有限公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UE设计</th>\n",
       "      <td>产品经理</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>面议</td>\n",
       "      <td>https://www.liepin.com/job/1927470629.shtml</td>\n",
       "      <td>福州-仓山区</td>\n",
       "      <td>福建星网智慧科技股份有限公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UE设计</th>\n",
       "      <td>前端开发工程师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1917595605.shtml</td>\n",
       "      <td>厦门</td>\n",
       "      <td>福建星网智慧科技股份有限公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UE设计</th>\n",
       "      <td>高级前端开发工程师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>12-20k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1928999925.shtml</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>广州市高科通信技术股份有限公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>400 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                          职称     学历     经验          薪水  \\\n",
       "关键词                                                      \n",
       "UE设计        122278高级UE4美术设计师   学历不限   3-5年  20-35k·12薪   \n",
       "UE设计                 高级交互设计师   统招本科  5-10年  15-30k·12薪   \n",
       "UE设计           120642高级交互设计师  本科及以上   1-3年  15-25k·12薪   \n",
       "UE设计        122059交互设计师（HMI）   学历不限   1-3年  20-40k·12薪   \n",
       "UE设计  UE_5G数字电路设计RTL/ASIC工程师  本科及以上   经验不限  20-50k·12薪   \n",
       "...                      ...    ...    ...         ...   \n",
       "UE设计                  资深产品经理  硕士及以上  5-10年  16-21k·12薪   \n",
       "UE设计              web前端开发工程师   统招本科  5-10年  18-30k·12薪   \n",
       "UE设计                    产品经理  大专及以上   经验不限          面议   \n",
       "UE设计                 前端开发工程师   统招本科   经验不限  10-15k·12薪   \n",
       "UE设计               高级前端开发工程师   统招本科   3-5年  12-20k·12薪   \n",
       "\n",
       "                                               链接    公司地点                公司名称  \\\n",
       "关键词                                                                             \n",
       "UE设计  https://www.liepin.com/job/1929583359.shtml  深圳-科技园                大疆创新   \n",
       "UE设计  https://www.liepin.com/job/1929235759.shtml      深圳      OPPO广东移动通信有限公司   \n",
       "UE设计  https://www.liepin.com/job/1925734479.shtml  深圳-科技园                大疆创新   \n",
       "UE设计  https://www.liepin.com/job/1927324629.shtml      深圳                大疆创新   \n",
       "UE设计  https://www.liepin.com/job/1922785255.shtml   上海-桃浦     中国电科新一代移动通信创新中心   \n",
       "...                                           ...     ...                 ...   \n",
       "UE设计  https://www.liepin.com/job/1928927927.shtml  郑州-中原区  中讯邮电咨询设计院有限公司郑州分公司   \n",
       "UE设计  https://www.liepin.com/job/1928195041.shtml  深圳-南山区      深圳市锐尔觅移动通信有限公司   \n",
       "UE设计  https://www.liepin.com/job/1927470629.shtml  福州-仓山区      福建星网智慧科技股份有限公司   \n",
       "UE设计  https://www.liepin.com/job/1917595605.shtml      厦门      福建星网智慧科技股份有限公司   \n",
       "UE设计  https://www.liepin.com/job/1928999925.shtml  广州-天河区     广州市高科通信技术股份有限公司   \n",
       "\n",
       "      页数  \n",
       "关键词       \n",
       "UE设计   0  \n",
       "UE设计   0  \n",
       "UE设计   0  \n",
       "UE设计   0  \n",
       "UE设计   0  \n",
       "...   ..  \n",
       "UE设计   9  \n",
       "UE设计   9  \n",
       "UE设计   9  \n",
       "UE设计   9  \n",
       "UE设计   9  \n",
       "\n",
       "[400 rows x 8 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_UE = df_all[['关键词','职称','学历','经验','薪水','链接','公司地点','公司名称','页数']].set_index(\"关键词\").loc['UE设计']\n",
    "df_UE.to_excel(\"UE设计.xlsx\",\\\n",
    "                sheet_name=\"游戏产业_UE设计\")\n",
    "df_UE"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 原画设计"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>职称</th>\n",
       "      <th>学历</th>\n",
       "      <th>经验</th>\n",
       "      <th>薪水</th>\n",
       "      <th>链接</th>\n",
       "      <th>公司地点</th>\n",
       "      <th>公司名称</th>\n",
       "      <th>页数</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>关键词</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>原画设计</th>\n",
       "      <td>原画师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>8-12k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1927325333.shtml</td>\n",
       "      <td>北京</td>\n",
       "      <td>北京掌信拓维科技发展有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>原画设计</th>\n",
       "      <td>3D设计/制作</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1927391403.shtml</td>\n",
       "      <td>北京</td>\n",
       "      <td>北京掌信拓维科技发展有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           职称     学历    经验          薪水  \\\n",
       "关键词                                      \n",
       "原画设计      原画师  本科及以上  经验不限   8-12k·12薪   \n",
       "原画设计  3D设计/制作  大专及以上  经验不限  10-15k·12薪   \n",
       "\n",
       "                                               链接 公司地点            公司名称  页数  \n",
       "关键词                                                                         \n",
       "原画设计  https://www.liepin.com/job/1927325333.shtml   北京  北京掌信拓维科技发展有限公司   0  \n",
       "原画设计  https://www.liepin.com/job/1927391403.shtml   北京  北京掌信拓维科技发展有限公司   0  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_原画 = df_all[['关键词','职称','学历','经验','薪水','链接','公司地点','公司名称','页数']].set_index(\"关键词\").loc['原画设计']\n",
    "df_原画.to_excel(\"原画设计.xlsx\",\\\n",
    "                sheet_name=\"游戏产业_原画设计\")\n",
    "df_原画"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 特效设计"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>职称</th>\n",
       "      <th>学历</th>\n",
       "      <th>经验</th>\n",
       "      <th>薪水</th>\n",
       "      <th>链接</th>\n",
       "      <th>公司地点</th>\n",
       "      <th>公司名称</th>\n",
       "      <th>页数</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>关键词</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>特效设计</th>\n",
       "      <td>游戏特效设计师</td>\n",
       "      <td>中专/中技及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929898875.shtml</td>\n",
       "      <td>北京</td>\n",
       "      <td>北京爱游互动科技有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>特效设计</th>\n",
       "      <td>3D场景特效设计师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>10-15k·13薪</td>\n",
       "      <td>https://www.liepin.com/job/1928277723.shtml</td>\n",
       "      <td>重庆-渝北区</td>\n",
       "      <td>亚信科技</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>特效设计</th>\n",
       "      <td>视频类项目经理</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>面议</td>\n",
       "      <td>https://www.liepin.com/job/1926778445.shtml</td>\n",
       "      <td>深圳</td>\n",
       "      <td>华为</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>特效设计</th>\n",
       "      <td>新媒体运营经理</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>15-20k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929930115.shtml</td>\n",
       "      <td></td>\n",
       "      <td>锐捷网络股份有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>特效设计</th>\n",
       "      <td>影视后期</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>7-12k·14薪</td>\n",
       "      <td>https://www.liepin.com/job/1929290021.shtml</td>\n",
       "      <td>厦门-思明区</td>\n",
       "      <td>厦门雅迅网络股份有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>特效设计</th>\n",
       "      <td>后期剪辑师</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>面议</td>\n",
       "      <td>https://www.liepin.com/job/1922315331.shtml</td>\n",
       "      <td>深圳</td>\n",
       "      <td>华为</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>特效设计</th>\n",
       "      <td>后期制作（偏平面）</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>6-8k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1926496747.shtml</td>\n",
       "      <td>成都</td>\n",
       "      <td>彩讯科技股份有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>特效设计</th>\n",
       "      <td>后期制作（偏平台）</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>6-8k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1926496731.shtml</td>\n",
       "      <td>成都</td>\n",
       "      <td>彩讯科技股份有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>特效设计</th>\n",
       "      <td>视频剪辑实习生</td>\n",
       "      <td>学历不限</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>3-6k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1928963733.shtml</td>\n",
       "      <td>大连</td>\n",
       "      <td>中棠文化科技(大连)有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>特效设计</th>\n",
       "      <td>高级3D设计师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>21-38k·12薪</td>\n",
       "      <td>https://www.liepin.com/a/20134159.shtml</td>\n",
       "      <td>上海-浦东新区</td>\n",
       "      <td>XXX国内知名手机研发生产公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>特效设计</th>\n",
       "      <td>高级3D设计师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>30-50k·12薪</td>\n",
       "      <td>https://www.liepin.com/a/20589047.shtml</td>\n",
       "      <td>上海</td>\n",
       "      <td>行业头部企业</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>特效设计</th>\n",
       "      <td>3D设计师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>25-45k·12薪</td>\n",
       "      <td>https://www.liepin.com/a/20013431.shtml</td>\n",
       "      <td>上海</td>\n",
       "      <td>知名上市通信公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>特效设计</th>\n",
       "      <td>新媒体运营（视频拍摄剪辑）</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>10-15k·13薪</td>\n",
       "      <td>https://www.liepin.com/a/21122487.shtml</td>\n",
       "      <td>深圳</td>\n",
       "      <td>北京科锐国际人力资源股份有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>特效设计</th>\n",
       "      <td>分镜头设计师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>7-12k·12薪</td>\n",
       "      <td>https://www.liepin.com/a/21112025.shtml</td>\n",
       "      <td>深圳-南山区</td>\n",
       "      <td>大型上市集团旗下通讯终端产品上市子公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>特效设计</th>\n",
       "      <td>视频剪辑</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>8-12k·13薪</td>\n",
       "      <td>https://www.liepin.com/job/1928065817.shtml</td>\n",
       "      <td>北京</td>\n",
       "      <td>华为终端有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>特效设计</th>\n",
       "      <td>视频摄像制作师</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>6-8k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1923810591.shtml</td>\n",
       "      <td>广州</td>\n",
       "      <td>广州浚峰网络技术有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>特效设计</th>\n",
       "      <td>视频编辑</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>6-8k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1923810589.shtml</td>\n",
       "      <td>广州</td>\n",
       "      <td>广州浚峰网络技术有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>特效设计</th>\n",
       "      <td>Java/Android/C++/C/AI算法/架构师/软件</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>40-70k·20薪</td>\n",
       "      <td>https://www.liepin.com/job/1926274495.shtml</td>\n",
       "      <td>东莞</td>\n",
       "      <td>华为</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>特效设计</th>\n",
       "      <td>视频运营</td>\n",
       "      <td>中专/中技及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>4-8k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1920237285.shtml</td>\n",
       "      <td>深圳-龙华区</td>\n",
       "      <td>深圳易天光通信有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>特效设计</th>\n",
       "      <td>3D建模师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>面议</td>\n",
       "      <td>https://www.liepin.com/job/1915831319.shtml</td>\n",
       "      <td></td>\n",
       "      <td>华为</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>特效设计</th>\n",
       "      <td>3D建模师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>面议</td>\n",
       "      <td>https://www.liepin.com/job/1915831307.shtml</td>\n",
       "      <td>上海-浦东新区</td>\n",
       "      <td>华为</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>特效设计</th>\n",
       "      <td>摄像师</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>8-10k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1926325691.shtml</td>\n",
       "      <td>深圳</td>\n",
       "      <td>深圳市冠群电子有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>特效设计</th>\n",
       "      <td>UI设计工程师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>8-10k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/195054564.shtml</td>\n",
       "      <td>北京-中关村</td>\n",
       "      <td>普天信息技术有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>特效设计</th>\n",
       "      <td>视频设计</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>6-8k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1916464863.shtml</td>\n",
       "      <td>北京</td>\n",
       "      <td>北京金日兴科技术有限责任公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  职称        学历     经验          薪水  \\\n",
       "关键词                                                                 \n",
       "特效设计                         游戏特效设计师  中专/中技及以上   3-5年  10-15k·12薪   \n",
       "特效设计                       3D场景特效设计师      统招本科   3-5年  10-15k·13薪   \n",
       "特效设计                         视频类项目经理      统招本科   3-5年          面议   \n",
       "特效设计                         新媒体运营经理     本科及以上   3-5年  15-20k·12薪   \n",
       "特效设计                            影视后期      统招本科  5-10年   7-12k·14薪   \n",
       "特效设计                           后期剪辑师     大专及以上   3-5年          面议   \n",
       "特效设计                       后期制作（偏平面）     本科及以上   1-3年    6-8k·12薪   \n",
       "特效设计                       后期制作（偏平台）     本科及以上   1-3年    6-8k·12薪   \n",
       "特效设计                         视频剪辑实习生      学历不限   经验不限    3-6k·12薪   \n",
       "特效设计                         高级3D设计师      统招本科   3-5年  21-38k·12薪   \n",
       "特效设计                         高级3D设计师      统招本科  5-10年  30-50k·12薪   \n",
       "特效设计                           3D设计师      统招本科   3-5年  25-45k·12薪   \n",
       "特效设计                   新媒体运营（视频拍摄剪辑）      统招本科   1-3年  10-15k·13薪   \n",
       "特效设计                          分镜头设计师     本科及以上   1-3年   7-12k·12薪   \n",
       "特效设计                            视频剪辑     大专及以上   3-5年   8-12k·13薪   \n",
       "特效设计                         视频摄像制作师     大专及以上   1-3年    6-8k·12薪   \n",
       "特效设计                            视频编辑     大专及以上   1-3年    6-8k·12薪   \n",
       "特效设计  Java/Android/C++/C/AI算法/架构师/软件     本科及以上   3-5年  40-70k·20薪   \n",
       "特效设计                            视频运营  中专/中技及以上   1-3年    4-8k·12薪   \n",
       "特效设计                           3D建模师      统招本科   3-5年          面议   \n",
       "特效设计                           3D建模师      统招本科   3-5年          面议   \n",
       "特效设计                             摄像师     大专及以上   1-3年   8-10k·12薪   \n",
       "特效设计                         UI设计工程师      统招本科   3-5年   8-10k·12薪   \n",
       "特效设计                            视频设计     大专及以上   1-3年    6-8k·12薪   \n",
       "\n",
       "                                               链接     公司地点  \\\n",
       "关键词                                                          \n",
       "特效设计  https://www.liepin.com/job/1929898875.shtml       北京   \n",
       "特效设计  https://www.liepin.com/job/1928277723.shtml   重庆-渝北区   \n",
       "特效设计  https://www.liepin.com/job/1926778445.shtml       深圳   \n",
       "特效设计  https://www.liepin.com/job/1929930115.shtml            \n",
       "特效设计  https://www.liepin.com/job/1929290021.shtml   厦门-思明区   \n",
       "特效设计  https://www.liepin.com/job/1922315331.shtml       深圳   \n",
       "特效设计  https://www.liepin.com/job/1926496747.shtml       成都   \n",
       "特效设计  https://www.liepin.com/job/1926496731.shtml       成都   \n",
       "特效设计  https://www.liepin.com/job/1928963733.shtml       大连   \n",
       "特效设计      https://www.liepin.com/a/20134159.shtml  上海-浦东新区   \n",
       "特效设计      https://www.liepin.com/a/20589047.shtml       上海   \n",
       "特效设计      https://www.liepin.com/a/20013431.shtml       上海   \n",
       "特效设计      https://www.liepin.com/a/21122487.shtml       深圳   \n",
       "特效设计      https://www.liepin.com/a/21112025.shtml   深圳-南山区   \n",
       "特效设计  https://www.liepin.com/job/1928065817.shtml       北京   \n",
       "特效设计  https://www.liepin.com/job/1923810591.shtml       广州   \n",
       "特效设计  https://www.liepin.com/job/1923810589.shtml       广州   \n",
       "特效设计  https://www.liepin.com/job/1926274495.shtml       东莞   \n",
       "特效设计  https://www.liepin.com/job/1920237285.shtml   深圳-龙华区   \n",
       "特效设计  https://www.liepin.com/job/1915831319.shtml            \n",
       "特效设计  https://www.liepin.com/job/1915831307.shtml  上海-浦东新区   \n",
       "特效设计  https://www.liepin.com/job/1926325691.shtml       深圳   \n",
       "特效设计   https://www.liepin.com/job/195054564.shtml   北京-中关村   \n",
       "特效设计  https://www.liepin.com/job/1916464863.shtml       北京   \n",
       "\n",
       "                     公司名称  页数  \n",
       "关键词                            \n",
       "特效设计         北京爱游互动科技有限公司   0  \n",
       "特效设计                 亚信科技   0  \n",
       "特效设计                   华为   0  \n",
       "特效设计           锐捷网络股份有限公司   0  \n",
       "特效设计         厦门雅迅网络股份有限公司   0  \n",
       "特效设计                   华为   0  \n",
       "特效设计           彩讯科技股份有限公司   0  \n",
       "特效设计           彩讯科技股份有限公司   0  \n",
       "特效设计       中棠文化科技(大连)有限公司   0  \n",
       "特效设计      XXX国内知名手机研发生产公司   0  \n",
       "特效设计               行业头部企业   0  \n",
       "特效设计             知名上市通信公司   0  \n",
       "特效设计     北京科锐国际人力资源股份有限公司   0  \n",
       "特效设计  大型上市集团旗下通讯终端产品上市子公司   0  \n",
       "特效设计             华为终端有限公司   0  \n",
       "特效设计         广州浚峰网络技术有限公司   0  \n",
       "特效设计         广州浚峰网络技术有限公司   0  \n",
       "特效设计                   华为   0  \n",
       "特效设计          深圳易天光通信有限公司   0  \n",
       "特效设计                   华为   0  \n",
       "特效设计                   华为   0  \n",
       "特效设计          深圳市冠群电子有限公司   0  \n",
       "特效设计           普天信息技术有限公司   0  \n",
       "特效设计       北京金日兴科技术有限责任公司   0  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_特效 = df_all[['关键词','职称','学历','经验','薪水','链接','公司地点','公司名称','页数']].set_index(\"关键词\").loc['特效设计']\n",
    "df_特效.to_excel(\"特效设计.xlsx\",\\\n",
    "                sheet_name=\"游戏产业_特效设计\")\n",
    "df_特效"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 模型设计"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>职称</th>\n",
       "      <th>学历</th>\n",
       "      <th>经验</th>\n",
       "      <th>薪水</th>\n",
       "      <th>链接</th>\n",
       "      <th>公司地点</th>\n",
       "      <th>公司名称</th>\n",
       "      <th>页数</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>关键词</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>模型设计</th>\n",
       "      <td>大数据etl工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>20-40k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929606263.shtml</td>\n",
       "      <td>上海</td>\n",
       "      <td>上海市信息管线</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>模型设计</th>\n",
       "      <td>ETL开发工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>20-40k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1930049169.shtml</td>\n",
       "      <td>上海</td>\n",
       "      <td>上海市信息管线</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>模型设计</th>\n",
       "      <td>通信工程师</td>\n",
       "      <td>硕士及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>12-21k·13薪</td>\n",
       "      <td>https://www.liepin.com/job/1929478361.shtml</td>\n",
       "      <td>南京-秦淮区</td>\n",
       "      <td>南京智能信通科技发展有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>模型设计</th>\n",
       "      <td>大数据开发工程师（中国联通网络AI中心）</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>面议</td>\n",
       "      <td>https://www.liepin.com/job/1926176561.shtml</td>\n",
       "      <td>南京-建邺区</td>\n",
       "      <td>中国联合网络通信有限公司江苏省分公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>模型设计</th>\n",
       "      <td>软件架构师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>25-35k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929628655.shtml</td>\n",
       "      <td>深圳-龙华区</td>\n",
       "      <td>深圳市科奈信科技有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>模型设计</th>\n",
       "      <td>Linux应用工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>10-16k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1927210193.shtml</td>\n",
       "      <td>合肥</td>\n",
       "      <td>移远通信</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>模型设计</th>\n",
       "      <td>Linux应用开发工程师(偏数据)</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>8-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1923452127.shtml</td>\n",
       "      <td>合肥</td>\n",
       "      <td>移远通信</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>模型设计</th>\n",
       "      <td>AI工程架构专家(007776)</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>40-70k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929277271.shtml</td>\n",
       "      <td>深圳-福田区</td>\n",
       "      <td>vivo</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>模型设计</th>\n",
       "      <td>Power软件工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>20-40k·16薪</td>\n",
       "      <td>https://www.liepin.com/a/20829765.shtml</td>\n",
       "      <td>深圳,广州,东莞</td>\n",
       "      <td>知名手机公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>模型设计</th>\n",
       "      <td>高级数据分析师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>20-25k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1922843797.shtml</td>\n",
       "      <td>深圳</td>\n",
       "      <td>斯凯荣</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>400 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        职称     学历     经验          薪水  \\\n",
       "关键词                                                    \n",
       "模型设计             大数据etl工程师  本科及以上  5-10年  20-40k·12薪   \n",
       "模型设计              ETL开发工程师  本科及以上  5-10年  20-40k·12薪   \n",
       "模型设计                 通信工程师  硕士及以上   经验不限  12-21k·13薪   \n",
       "模型设计  大数据开发工程师（中国联通网络AI中心）   统招本科   1-3年          面议   \n",
       "模型设计                 软件架构师  本科及以上   3-5年  25-35k·12薪   \n",
       "...                    ...    ...    ...         ...   \n",
       "模型设计            Linux应用工程师  本科及以上   1-3年  10-16k·12薪   \n",
       "模型设计     Linux应用开发工程师(偏数据)  本科及以上   3-5年   8-15k·12薪   \n",
       "模型设计      AI工程架构专家(007776)  本科及以上  5-10年  40-70k·12薪   \n",
       "模型设计            Power软件工程师  本科及以上   1-3年  20-40k·16薪   \n",
       "模型设计               高级数据分析师  本科及以上   3-5年  20-25k·12薪   \n",
       "\n",
       "                                               链接      公司地点  \\\n",
       "关键词                                                           \n",
       "模型设计  https://www.liepin.com/job/1929606263.shtml        上海   \n",
       "模型设计  https://www.liepin.com/job/1930049169.shtml        上海   \n",
       "模型设计  https://www.liepin.com/job/1929478361.shtml    南京-秦淮区   \n",
       "模型设计  https://www.liepin.com/job/1926176561.shtml    南京-建邺区   \n",
       "模型设计  https://www.liepin.com/job/1929628655.shtml    深圳-龙华区   \n",
       "...                                           ...       ...   \n",
       "模型设计  https://www.liepin.com/job/1927210193.shtml        合肥   \n",
       "模型设计  https://www.liepin.com/job/1923452127.shtml        合肥   \n",
       "模型设计  https://www.liepin.com/job/1929277271.shtml    深圳-福田区   \n",
       "模型设计      https://www.liepin.com/a/20829765.shtml  深圳,广州,东莞   \n",
       "模型设计  https://www.liepin.com/job/1922843797.shtml        深圳   \n",
       "\n",
       "                    公司名称  页数  \n",
       "关键词                           \n",
       "模型设计             上海市信息管线   0  \n",
       "模型设计             上海市信息管线   0  \n",
       "模型设计      南京智能信通科技发展有限公司   0  \n",
       "模型设计  中国联合网络通信有限公司江苏省分公司   0  \n",
       "模型设计        深圳市科奈信科技有限公司   0  \n",
       "...                  ...  ..  \n",
       "模型设计                移远通信   9  \n",
       "模型设计                移远通信   9  \n",
       "模型设计                vivo   9  \n",
       "模型设计              知名手机公司   9  \n",
       "模型设计                 斯凯荣   9  \n",
       "\n",
       "[400 rows x 8 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_模型 = df_all[['关键词','职称','学历','经验','薪水','链接','公司地点','公司名称','页数']].set_index(\"关键词\").loc['模型设计']\n",
    "df_模型.to_excel(\"模型设计.xlsx\",\\\n",
    "                sheet_name=\"游戏产业_模型设计\")\n",
    "df_模型"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 岗位地区需求动向\n",
    "主要：北、上、广、深、重"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>关键词</th>\n",
       "      <th>职称</th>\n",
       "      <th>学历</th>\n",
       "      <th>经验</th>\n",
       "      <th>薪水</th>\n",
       "      <th>链接</th>\n",
       "      <th>公司地点</th>\n",
       "      <th>公司名称</th>\n",
       "      <th>页数</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>序</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>资深ui设计师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>25-40k·16薪</td>\n",
       "      <td>https://www.liepin.com/job/1930040433.shtml</td>\n",
       "      <td>上海</td>\n",
       "      <td>千云(上海)信息科技有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>UI设计</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>面议</td>\n",
       "      <td>https://www.liepin.com/job/1927897597.shtml</td>\n",
       "      <td>镇江</td>\n",
       "      <td>中国联合网络通信有限公司江苏省分公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>初级UI设计师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>面议</td>\n",
       "      <td>https://www.liepin.com/job/1926982717.shtml</td>\n",
       "      <td>南京-建邺区</td>\n",
       "      <td>中国联合网络通信有限公司江苏省分公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>ui设计</td>\n",
       "      <td>学历不限</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>6-12k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1925162677.shtml</td>\n",
       "      <td>佛山-顺德区</td>\n",
       "      <td>广东顺德中电信息技术有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>前端界面设计</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>8-15k·13薪</td>\n",
       "      <td>https://www.liepin.com/job/1925495583.shtml</td>\n",
       "      <td>福州-中亭街</td>\n",
       "      <td>金钱猫科技股份有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1221</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>Linux应用工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>10-16k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1927210193.shtml</td>\n",
       "      <td>合肥</td>\n",
       "      <td>移远通信</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1222</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>Linux应用开发工程师(偏数据)</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>8-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1923452127.shtml</td>\n",
       "      <td>合肥</td>\n",
       "      <td>移远通信</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1223</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>AI工程架构专家(007776)</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>40-70k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929277271.shtml</td>\n",
       "      <td>深圳-福田区</td>\n",
       "      <td>vivo</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1224</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>Power软件工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>20-40k·16薪</td>\n",
       "      <td>https://www.liepin.com/a/20829765.shtml</td>\n",
       "      <td>深圳,广州,东莞</td>\n",
       "      <td>知名手机公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1225</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>高级数据分析师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>20-25k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1922843797.shtml</td>\n",
       "      <td>深圳</td>\n",
       "      <td>斯凯荣</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1226 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       关键词                 职称     学历     经验          薪水  \\\n",
       "序                                                         \n",
       "0     UI设计            资深ui设计师  本科及以上   3-5年  25-40k·16薪   \n",
       "1     UI设计               UI设计   统招本科   经验不限          面议   \n",
       "2     UI设计            初级UI设计师   统招本科   1-3年          面议   \n",
       "3     UI设计               ui设计   学历不限   经验不限   6-12k·12薪   \n",
       "4     UI设计             前端界面设计   统招本科   1-3年   8-15k·13薪   \n",
       "...    ...                ...    ...    ...         ...   \n",
       "1221  模型设计         Linux应用工程师  本科及以上   1-3年  10-16k·12薪   \n",
       "1222  模型设计  Linux应用开发工程师(偏数据)  本科及以上   3-5年   8-15k·12薪   \n",
       "1223  模型设计   AI工程架构专家(007776)  本科及以上  5-10年  40-70k·12薪   \n",
       "1224  模型设计         Power软件工程师  本科及以上   1-3年  20-40k·16薪   \n",
       "1225  模型设计            高级数据分析师  本科及以上   3-5年  20-25k·12薪   \n",
       "\n",
       "                                               链接      公司地点  \\\n",
       "序                                                             \n",
       "0     https://www.liepin.com/job/1930040433.shtml        上海   \n",
       "1     https://www.liepin.com/job/1927897597.shtml        镇江   \n",
       "2     https://www.liepin.com/job/1926982717.shtml    南京-建邺区   \n",
       "3     https://www.liepin.com/job/1925162677.shtml    佛山-顺德区   \n",
       "4     https://www.liepin.com/job/1925495583.shtml    福州-中亭街   \n",
       "...                                           ...       ...   \n",
       "1221  https://www.liepin.com/job/1927210193.shtml        合肥   \n",
       "1222  https://www.liepin.com/job/1923452127.shtml        合肥   \n",
       "1223  https://www.liepin.com/job/1929277271.shtml    深圳-福田区   \n",
       "1224      https://www.liepin.com/a/20829765.shtml  深圳,广州,东莞   \n",
       "1225  https://www.liepin.com/job/1922843797.shtml        深圳   \n",
       "\n",
       "                    公司名称  页数  \n",
       "序                             \n",
       "0         千云(上海)信息科技有限公司   0  \n",
       "1     中国联合网络通信有限公司江苏省分公司   0  \n",
       "2     中国联合网络通信有限公司江苏省分公司   0  \n",
       "3         广东顺德中电信息技术有限公司   0  \n",
       "4            金钱猫科技股份有限公司   0  \n",
       "...                  ...  ..  \n",
       "1221                移远通信   9  \n",
       "1222                移远通信   9  \n",
       "1223                vivo   9  \n",
       "1224              知名手机公司   9  \n",
       "1225                 斯凯荣   9  \n",
       "\n",
       "[1226 rows x 9 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_all_1 = df_all[['关键词','职称','学历','经验','薪水','链接','公司地点','公司名称','页数']]\n",
    "df_all_1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>关键词</th>\n",
       "      <th>职称</th>\n",
       "      <th>学历</th>\n",
       "      <th>经验</th>\n",
       "      <th>薪水</th>\n",
       "      <th>链接</th>\n",
       "      <th>公司名称</th>\n",
       "      <th>页数</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>公司地点</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>北京</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>UI设计师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>10-14k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929997411.shtml</td>\n",
       "      <td>中数通信息</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>UI设计师-北京</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>10-20k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1923032381.shtml</td>\n",
       "      <td>杭州迪普科技股份有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>ui设计师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>7-9k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929684197.shtml</td>\n",
       "      <td>多洛塔(北京)安全技术有限公司</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>ui设计师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929635845.shtml</td>\n",
       "      <td>北京创联云睿科技有限公司</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>UI设计师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>15-20k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1914181728.shtml</td>\n",
       "      <td>汇智通信</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>BI架构师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>18-26k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/194882032.shtml</td>\n",
       "      <td>四达软件北京</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>Java web 开发工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>10-20k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1923762547.shtml</td>\n",
       "      <td>卓望控股有限公司</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>数据库开发工程师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1916284623.shtml</td>\n",
       "      <td>亚信科技</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>高级AI场景理解专家</td>\n",
       "      <td>硕士及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>面议</td>\n",
       "      <td>https://www.liepin.com/job/1923102845.shtml</td>\n",
       "      <td>华为</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>AI场景理解高级专家</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>40-55k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1920340453.shtml</td>\n",
       "      <td>华为</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>104 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       关键词              职称     学历     经验          薪水  \\\n",
       "公司地点                                                   \n",
       "北京    UI设计           UI设计师  本科及以上   1-3年  10-14k·12薪   \n",
       "北京    UI设计        UI设计师-北京   统招本科   1-3年  10-20k·12薪   \n",
       "北京    UI设计           ui设计师  本科及以上   1-3年    7-9k·12薪   \n",
       "北京    UI设计           ui设计师  本科及以上   经验不限  10-15k·12薪   \n",
       "北京    UI设计           UI设计师   统招本科   3-5年  15-20k·12薪   \n",
       "...    ...             ...    ...    ...         ...   \n",
       "北京    模型设计           BI架构师   统招本科  5-10年  18-26k·12薪   \n",
       "北京    模型设计  Java web 开发工程师  本科及以上   3-5年  10-20k·12薪   \n",
       "北京    模型设计        数据库开发工程师   统招本科   3-5年  10-15k·12薪   \n",
       "北京    模型设计      高级AI场景理解专家  硕士及以上  5-10年          面议   \n",
       "北京    模型设计      AI场景理解高级专家  本科及以上  5-10年  40-55k·12薪   \n",
       "\n",
       "                                               链接             公司名称  页数  \n",
       "公司地点                                                                    \n",
       "北京    https://www.liepin.com/job/1929997411.shtml            中数通信息   0  \n",
       "北京    https://www.liepin.com/job/1923032381.shtml     杭州迪普科技股份有限公司   0  \n",
       "北京    https://www.liepin.com/job/1929684197.shtml  多洛塔(北京)安全技术有限公司   1  \n",
       "北京    https://www.liepin.com/job/1929635845.shtml     北京创联云睿科技有限公司   1  \n",
       "北京    https://www.liepin.com/job/1914181728.shtml             汇智通信   1  \n",
       "...                                           ...              ...  ..  \n",
       "北京     https://www.liepin.com/job/194882032.shtml           四达软件北京   7  \n",
       "北京    https://www.liepin.com/job/1923762547.shtml         卓望控股有限公司   7  \n",
       "北京    https://www.liepin.com/job/1916284623.shtml             亚信科技   8  \n",
       "北京    https://www.liepin.com/job/1923102845.shtml               华为   9  \n",
       "北京    https://www.liepin.com/job/1920340453.shtml               华为   9  \n",
       "\n",
       "[104 rows x 8 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_北 = df_all_1.set_index(\"公司地点\").loc['北京']\n",
    "df_北.to_excel(\"北_游戏产业_产品设计.xlsx\",\\\n",
    "              sheet_name=\"北京\")\n",
    "df_北"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>关键词</th>\n",
       "      <th>职称</th>\n",
       "      <th>学历</th>\n",
       "      <th>经验</th>\n",
       "      <th>薪水</th>\n",
       "      <th>链接</th>\n",
       "      <th>公司名称</th>\n",
       "      <th>页数</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>公司地点</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>上海</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>资深ui设计师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>25-40k·16薪</td>\n",
       "      <td>https://www.liepin.com/job/1930040433.shtml</td>\n",
       "      <td>千云(上海)信息科技有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>上海</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>ui设计师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>6-13k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929564735.shtml</td>\n",
       "      <td>彩讯科技股份有限公司</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>上海</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>UI/UE设计师（外包）</td>\n",
       "      <td>学历不限</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>8-11k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929279661.shtml</td>\n",
       "      <td>彩讯科技股份有限公司</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>上海</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>WEB前端开发工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1917278825.shtml</td>\n",
       "      <td>上海汇珏</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>上海</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>高级视觉设计师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>25-40k·13薪</td>\n",
       "      <td>https://www.liepin.com/a/21003123.shtml</td>\n",
       "      <td>某知名手机企业</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>上海</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>影像算法技术规划专家(006997)</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>50-70k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1926917071.shtml</td>\n",
       "      <td>vivo</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>上海</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>ID设计师(J10211)</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>8-10k·15薪</td>\n",
       "      <td>https://www.liepin.com/job/1921611495.shtml</td>\n",
       "      <td>华勤通讯</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>上海</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>大数据工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>面议</td>\n",
       "      <td>https://www.liepin.com/job/1921180779.shtml</td>\n",
       "      <td>亚信科技</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>上海</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>高级人工智能工程师（智慧交通领域）</td>\n",
       "      <td>硕士及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>面议</td>\n",
       "      <td>https://www.liepin.com/job/1916320935.shtml</td>\n",
       "      <td>中移(上海)信息通信科技有限公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>上海</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>高级人工智能工程师（工业能源领域）</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>面议</td>\n",
       "      <td>https://www.liepin.com/job/1916318357.shtml</td>\n",
       "      <td>中移(上海)信息通信科技有限公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>62 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       关键词                  职称     学历     经验          薪水  \\\n",
       "公司地点                                                       \n",
       "上海    UI设计             资深ui设计师  本科及以上   3-5年  25-40k·16薪   \n",
       "上海    UI设计               ui设计师  本科及以上   1-3年   6-13k·12薪   \n",
       "上海    UI设计        UI/UE设计师（外包）   学历不限   经验不限   8-11k·12薪   \n",
       "上海    UI设计          WEB前端开发工程师  本科及以上   1-3年  10-15k·12薪   \n",
       "上海    UI设计             高级视觉设计师   统招本科   经验不限  25-40k·13薪   \n",
       "...    ...                 ...    ...    ...         ...   \n",
       "上海    模型设计  影像算法技术规划专家(006997)   统招本科  5-10年  50-70k·12薪   \n",
       "上海    模型设计       ID设计师(J10211)  本科及以上   1-3年   8-10k·15薪   \n",
       "上海    模型设计              大数据工程师  本科及以上   1-3年          面议   \n",
       "上海    模型设计   高级人工智能工程师（智慧交通领域）  硕士及以上   3-5年          面议   \n",
       "上海    模型设计   高级人工智能工程师（工业能源领域）   统招本科   3-5年          面议   \n",
       "\n",
       "                                               链接              公司名称  页数  \n",
       "公司地点                                                                     \n",
       "上海    https://www.liepin.com/job/1930040433.shtml    千云(上海)信息科技有限公司   0  \n",
       "上海    https://www.liepin.com/job/1929564735.shtml        彩讯科技股份有限公司   1  \n",
       "上海    https://www.liepin.com/job/1929279661.shtml        彩讯科技股份有限公司   1  \n",
       "上海    https://www.liepin.com/job/1917278825.shtml              上海汇珏   4  \n",
       "上海        https://www.liepin.com/a/21003123.shtml           某知名手机企业   4  \n",
       "...                                           ...               ...  ..  \n",
       "上海    https://www.liepin.com/job/1926917071.shtml              vivo   6  \n",
       "上海    https://www.liepin.com/job/1921611495.shtml              华勤通讯   6  \n",
       "上海    https://www.liepin.com/job/1921180779.shtml              亚信科技   8  \n",
       "上海    https://www.liepin.com/job/1916320935.shtml  中移(上海)信息通信科技有限公司   9  \n",
       "上海    https://www.liepin.com/job/1916318357.shtml  中移(上海)信息通信科技有限公司   9  \n",
       "\n",
       "[62 rows x 8 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_上 = df_all_1.set_index(\"公司地点\").loc['上海']\n",
    "df_上.to_excel(\"上_游戏产业_产品设计.xlsx\",\\\n",
    "              sheet_name=\"上海\")\n",
    "df_上"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>关键词</th>\n",
       "      <th>职称</th>\n",
       "      <th>学历</th>\n",
       "      <th>经验</th>\n",
       "      <th>薪水</th>\n",
       "      <th>链接</th>\n",
       "      <th>公司名称</th>\n",
       "      <th>页数</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>公司地点</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>UI设计师（外包）</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>8-12k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929162439.shtml</td>\n",
       "      <td>彩讯科技股份有限公司</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>UI设计</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>8-12k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1916647853.shtml</td>\n",
       "      <td>联通通信</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>UI工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>8-12k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1928536745.shtml</td>\n",
       "      <td>广州市高科通信技术股份有限公司</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>客户端开发</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>11-20k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1927586951.shtml</td>\n",
       "      <td>广信通信</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>Android客户端 研发工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>11-20k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1925586623.shtml</td>\n",
       "      <td>广信通信</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>前台开发（外派）</td>\n",
       "      <td>学历不限</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929724117.shtml</td>\n",
       "      <td>公诚管理咨询有限公司第一分公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>ios开发工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>15-20k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929684589.shtml</td>\n",
       "      <td>彩讯科技股份有限公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>UE设计</td>\n",
       "      <td>UE设计师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>8-16k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1926603093.shtml</td>\n",
       "      <td>中国联通广东省分公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>UE设计</td>\n",
       "      <td>web前端开发工程师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>12-20k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1927077159.shtml</td>\n",
       "      <td>广州润芯信息技术有限公司</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>UE设计</td>\n",
       "      <td>UI工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>8-12k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1928536745.shtml</td>\n",
       "      <td>广州市高科通信技术股份有限公司</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>UE设计</td>\n",
       "      <td>UI设计师（外包）</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>8-12k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929162439.shtml</td>\n",
       "      <td>彩讯科技股份有限公司</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>UE设计</td>\n",
       "      <td>产品设计</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>10-30k·20薪</td>\n",
       "      <td>https://www.liepin.com/job/1916825463.shtml</td>\n",
       "      <td>中国电信上海</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>特效设计</td>\n",
       "      <td>视频摄像制作师</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>6-8k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1923810591.shtml</td>\n",
       "      <td>广州浚峰网络技术有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>特效设计</td>\n",
       "      <td>视频编辑</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>6-8k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1923810589.shtml</td>\n",
       "      <td>广州浚峰网络技术有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>人力资源经理</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>15-25k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929775301.shtml</td>\n",
       "      <td>广东博思汇通信息技术有限公司</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>人力资源主管</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>15-25k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929775219.shtml</td>\n",
       "      <td>广东博思汇通信息技术有限公司</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>BIM高级工程师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>13-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1925868057.shtml</td>\n",
       "      <td>公诚管理咨询有限公司第一分公司</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>招聘经理/主管</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929516337.shtml</td>\n",
       "      <td>广东博思汇通信息技术有限公司</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>大数据工程师——2019校园招聘</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>7-10k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1916370385.shtml</td>\n",
       "      <td>中数通信息</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>算法工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>15-25k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1921725995.shtml</td>\n",
       "      <td>恒安嘉新</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>java高级工程师（东莞 岗位）</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>20-40k·18薪</td>\n",
       "      <td>https://www.liepin.com/job/1919189775.shtml</td>\n",
       "      <td>华为</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>人力资源经理/主管</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929321145.shtml</td>\n",
       "      <td>广东博思汇通信息技术有限公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       关键词                职称     学历     经验          薪水  \\\n",
       "公司地点                                                     \n",
       "广州    UI设计         UI设计师（外包）  本科及以上   经验不限   8-12k·12薪   \n",
       "广州    UI设计              UI设计  本科及以上   1-3年   8-12k·12薪   \n",
       "广州    UI设计             UI工程师  本科及以上   经验不限   8-12k·12薪   \n",
       "广州    UI设计             客户端开发   统招本科   1-3年  11-20k·12薪   \n",
       "广州    UI设计  Android客户端 研发工程师  本科及以上   1-3年  11-20k·12薪   \n",
       "广州    UI设计          前台开发（外派）   学历不限   经验不限  10-15k·12薪   \n",
       "广州    UI设计          ios开发工程师  本科及以上   3-5年  15-20k·12薪   \n",
       "广州    UE设计             UE设计师  本科及以上   3-5年   8-16k·12薪   \n",
       "广州    UE设计        web前端开发工程师   统招本科   1-3年  12-20k·12薪   \n",
       "广州    UE设计             UI工程师  本科及以上   经验不限   8-12k·12薪   \n",
       "广州    UE设计         UI设计师（外包）  本科及以上   经验不限   8-12k·12薪   \n",
       "广州    UE设计              产品设计   统招本科   1-3年  10-30k·20薪   \n",
       "广州    特效设计           视频摄像制作师  大专及以上   1-3年    6-8k·12薪   \n",
       "广州    特效设计              视频编辑  大专及以上   1-3年    6-8k·12薪   \n",
       "广州    模型设计            人力资源经理  本科及以上   经验不限  15-25k·12薪   \n",
       "广州    模型设计            人力资源主管  本科及以上   经验不限  15-25k·12薪   \n",
       "广州    模型设计          BIM高级工程师   统招本科   3-5年  13-15k·12薪   \n",
       "广州    模型设计           招聘经理/主管  本科及以上  5-10年  10-15k·12薪   \n",
       "广州    模型设计  大数据工程师——2019校园招聘  本科及以上   经验不限   7-10k·12薪   \n",
       "广州    模型设计             算法工程师  本科及以上   3-5年  15-25k·12薪   \n",
       "广州    模型设计  java高级工程师（东莞 岗位）   统招本科   3-5年  20-40k·18薪   \n",
       "广州    模型设计         人力资源经理/主管  本科及以上   经验不限  10-15k·12薪   \n",
       "\n",
       "                                               链接             公司名称  页数  \n",
       "公司地点                                                                    \n",
       "广州    https://www.liepin.com/job/1929162439.shtml       彩讯科技股份有限公司   1  \n",
       "广州    https://www.liepin.com/job/1916647853.shtml             联通通信   2  \n",
       "广州    https://www.liepin.com/job/1928536745.shtml  广州市高科通信技术股份有限公司   4  \n",
       "广州    https://www.liepin.com/job/1927586951.shtml             广信通信   5  \n",
       "广州    https://www.liepin.com/job/1925586623.shtml             广信通信   5  \n",
       "广州    https://www.liepin.com/job/1929724117.shtml  公诚管理咨询有限公司第一分公司   9  \n",
       "广州    https://www.liepin.com/job/1929684589.shtml       彩讯科技股份有限公司   9  \n",
       "广州    https://www.liepin.com/job/1926603093.shtml       中国联通广东省分公司   0  \n",
       "广州    https://www.liepin.com/job/1927077159.shtml     广州润芯信息技术有限公司   5  \n",
       "广州    https://www.liepin.com/job/1928536745.shtml  广州市高科通信技术股份有限公司   7  \n",
       "广州    https://www.liepin.com/job/1929162439.shtml       彩讯科技股份有限公司   7  \n",
       "广州    https://www.liepin.com/job/1916825463.shtml           中国电信上海   9  \n",
       "广州    https://www.liepin.com/job/1923810591.shtml     广州浚峰网络技术有限公司   0  \n",
       "广州    https://www.liepin.com/job/1923810589.shtml     广州浚峰网络技术有限公司   0  \n",
       "广州    https://www.liepin.com/job/1929775301.shtml   广东博思汇通信息技术有限公司   3  \n",
       "广州    https://www.liepin.com/job/1929775219.shtml   广东博思汇通信息技术有限公司   3  \n",
       "广州    https://www.liepin.com/job/1925868057.shtml  公诚管理咨询有限公司第一分公司   3  \n",
       "广州    https://www.liepin.com/job/1929516337.shtml   广东博思汇通信息技术有限公司   5  \n",
       "广州    https://www.liepin.com/job/1916370385.shtml            中数通信息   6  \n",
       "广州    https://www.liepin.com/job/1921725995.shtml             恒安嘉新   7  \n",
       "广州    https://www.liepin.com/job/1919189775.shtml               华为   8  \n",
       "广州    https://www.liepin.com/job/1929321145.shtml   广东博思汇通信息技术有限公司   9  "
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_广 = df_all_1.set_index(\"公司地点\").loc['广州']\n",
    "df_广.to_excel(\"广_游戏产业_产品设计.xlsx\",\\\n",
    "              sheet_name=\"广州\")\n",
    "df_广"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>关键词</th>\n",
       "      <th>职称</th>\n",
       "      <th>学历</th>\n",
       "      <th>经验</th>\n",
       "      <th>薪水</th>\n",
       "      <th>链接</th>\n",
       "      <th>公司名称</th>\n",
       "      <th>页数</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>公司地点</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>深圳</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>App UI前端设计师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>8-10k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929685469.shtml</td>\n",
       "      <td>深圳杰睿联科技有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>深圳</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>高级UI设计师</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>15-25k·12薪</td>\n",
       "      <td>https://www.liepin.com/a/21307263.shtml</td>\n",
       "      <td>世界500强公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>深圳</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>UI设计师</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>15-25k·12薪</td>\n",
       "      <td>https://www.liepin.com/a/21192825.shtml</td>\n",
       "      <td>某500强公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>深圳</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>UI开发工程师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>12-20k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929607091.shtml</td>\n",
       "      <td>兴硕信息科技(上海)有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>深圳</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>UI设计师(CPSZ-I2007)</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>15-20k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929880127.shtml</td>\n",
       "      <td>深圳市万邑通信息科技有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>深圳</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>BI技术架构师-797998829915</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>面议</td>\n",
       "      <td>https://www.liepin.com/job/1925851411.shtml</td>\n",
       "      <td>华为</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>深圳</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>BI技术架构师-797998829914</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>面议</td>\n",
       "      <td>https://www.liepin.com/job/1925849105.shtml</td>\n",
       "      <td>华为</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>深圳</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>设计开发中心- 高级ID设计师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>面议</td>\n",
       "      <td>https://www.liepin.com/job/1918347421.shtml</td>\n",
       "      <td>中国移动通信集团终端有限公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>深圳</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>化工系统流程设计</td>\n",
       "      <td>硕士及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>8-12k·13薪</td>\n",
       "      <td>https://www.liepin.com/a/20873215.shtml</td>\n",
       "      <td>某人才公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>深圳</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>高级数据分析师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>20-25k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1922843797.shtml</td>\n",
       "      <td>斯凯荣</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>159 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       关键词                    职称     学历     经验          薪水  \\\n",
       "公司地点                                                         \n",
       "深圳    UI设计           App UI前端设计师  本科及以上   1-3年   8-10k·12薪   \n",
       "深圳    UI设计               高级UI设计师  大专及以上   3-5年  15-25k·12薪   \n",
       "深圳    UI设计                 UI设计师  大专及以上   1-3年  15-25k·12薪   \n",
       "深圳    UI设计               UI开发工程师   统招本科   1-3年  12-20k·12薪   \n",
       "深圳    UI设计     UI设计师(CPSZ-I2007)  本科及以上   3-5年  15-20k·12薪   \n",
       "...    ...                   ...    ...    ...         ...   \n",
       "深圳    模型设计  BI技术架构师-797998829915  本科及以上  5-10年          面议   \n",
       "深圳    模型设计  BI技术架构师-797998829914  本科及以上  5-10年          面议   \n",
       "深圳    模型设计       设计开发中心- 高级ID设计师   统招本科   3-5年          面议   \n",
       "深圳    模型设计              化工系统流程设计  硕士及以上   经验不限   8-12k·13薪   \n",
       "深圳    模型设计               高级数据分析师  本科及以上   3-5年  20-25k·12薪   \n",
       "\n",
       "                                               链接            公司名称  页数  \n",
       "公司地点                                                                   \n",
       "深圳    https://www.liepin.com/job/1929685469.shtml     深圳杰睿联科技有限公司   0  \n",
       "深圳        https://www.liepin.com/a/21307263.shtml        世界500强公司   0  \n",
       "深圳        https://www.liepin.com/a/21192825.shtml         某500强公司   0  \n",
       "深圳    https://www.liepin.com/job/1929607091.shtml  兴硕信息科技(上海)有限公司   0  \n",
       "深圳    https://www.liepin.com/job/1929880127.shtml  深圳市万邑通信息科技有限公司   0  \n",
       "...                                           ...             ...  ..  \n",
       "深圳    https://www.liepin.com/job/1925851411.shtml              华为   9  \n",
       "深圳    https://www.liepin.com/job/1925849105.shtml              华为   9  \n",
       "深圳    https://www.liepin.com/job/1918347421.shtml  中国移动通信集团终端有限公司   9  \n",
       "深圳        https://www.liepin.com/a/20873215.shtml           某人才公司   9  \n",
       "深圳    https://www.liepin.com/job/1922843797.shtml             斯凯荣   9  \n",
       "\n",
       "[159 rows x 8 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_深 = df_all_1.set_index(\"公司地点\").loc['深圳']\n",
    "df_深.to_excel(\"深_游戏产业_产品设计.xlsx\",\\\n",
    "              sheet_name=\"深圳\")\n",
    "df_深"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>关键词</th>\n",
       "      <th>职称</th>\n",
       "      <th>学历</th>\n",
       "      <th>经验</th>\n",
       "      <th>薪水</th>\n",
       "      <th>链接</th>\n",
       "      <th>公司名称</th>\n",
       "      <th>页数</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>公司地点</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>重庆</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>ui设计师</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>6-8k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1921479485.shtml</td>\n",
       "      <td>南京华苏科技有限公司</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>重庆</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>架构师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>15-22k·12薪</td>\n",
       "      <td>https://www.liepin.com/a/21306545.shtml</td>\n",
       "      <td>XXXXXX科技有限公司</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>重庆</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>会员营销产品经理</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1926197937.shtml</td>\n",
       "      <td>重庆先特</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>重庆</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>大数据架构工程师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>15-25k·12薪</td>\n",
       "      <td>https://www.liepin.com/a/20710381.shtml</td>\n",
       "      <td>某大型国有企业</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>重庆</th>\n",
       "      <td>模型设计</td>\n",
       "      <td>模型工程师</td>\n",
       "      <td>硕士及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>13-25k·12薪</td>\n",
       "      <td>https://www.liepin.com/a/20928183.shtml</td>\n",
       "      <td>某国企半导体企业</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       关键词        职称     学历    经验          薪水  \\\n",
       "公司地点                                            \n",
       "重庆    UI设计     ui设计师  大专及以上  3-5年    6-8k·12薪   \n",
       "重庆    UI设计       架构师   统招本科  3-5年  15-22k·12薪   \n",
       "重庆    模型设计  会员营销产品经理   统招本科  3-5年  10-15k·12薪   \n",
       "重庆    模型设计  大数据架构工程师   统招本科  经验不限  15-25k·12薪   \n",
       "重庆    模型设计     模型工程师  硕士及以上  经验不限  13-25k·12薪   \n",
       "\n",
       "                                               链接          公司名称  页数  \n",
       "公司地点                                                                 \n",
       "重庆    https://www.liepin.com/job/1921479485.shtml    南京华苏科技有限公司   3  \n",
       "重庆        https://www.liepin.com/a/21306545.shtml  XXXXXX科技有限公司   6  \n",
       "重庆    https://www.liepin.com/job/1926197937.shtml          重庆先特   3  \n",
       "重庆        https://www.liepin.com/a/20710381.shtml       某大型国有企业   4  \n",
       "重庆        https://www.liepin.com/a/20928183.shtml      某国企半导体企业   5  "
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_重 = df_all_1.set_index(\"公司地点\").loc['重庆']\n",
    "df_重.to_excel(\"重_游戏产业_产品设计.xlsx\",\\\n",
    "              sheet_name=\"重庆\")\n",
    "df_重"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}
